Right now we're using a very, very old Microsoft Access database to track the shelter's animals. It only allows one person to open it at a time (it's on a network drive with sharing with record lock enabled on every instance of the program, I can't find anything else to try). The problem is our internet is extremely unreliable, so a 100% online solution isn't at all feasible for us because we need to be able to access it at all times. Ideally, a program would store the database on the internal network and then sync with an online database when internet connection is available (kind of like how Google Drive works -- even if you don't have access to the internet, you can still access the last instance of the files that were synced to the computer).
The database is used for animal-related purposes only -- intake, medical, fosters, outcomes. In addition, we need to generate several different reports -- weekly stray reports, follow up reports, monthly billing to the municipalities we serve (which pulls where the animal was found, the owner information if the animal was reclaimed, and the fines and fees that need to be paid to the municipality, separated by municipality). We also need the ability to create custom queries/reports.
Is there anything out there that would meet our needs?
#DataandTechnology