Access is not supported by my company and no one in our building of 1,000 people is familiar enough with Access to provide any help with my issue. We utilize an old database that is split into 2, with 20 users going in and out of it every day. I know just enough to make updates to the forms when necessary. The issue we've been having is that since we started working remotely in March, the database has been extremely slow. It takes around 30 seconds to open and close, up to a minute to search for an existing entry, and when inserting small amounts of data into the main form within the database, each entry can take up to 10 seconds to populate and allow the user to move on to the next cell.
We've reached a point where we can no longer continue using it. We've been using it because it allows multiple users to make entries at the same time. Shareable excel files have their issues, and smartsheet has a limit on the number of records that can be entered. This Access database used to have over 20,000 records in it, but in an attempt to speed it up, I had exported the old records and deleted them, but it did not improve speed.
My question is...is anyone familiar with a web-based database program that is most similar to using Access? It has to be free because my company is not approving new requests for funding towards these sort of things due to COVID cuts. I've seen that there are several free databases available, but if anyone can definitively say which ones might be most comparable to Access that would help a lot.