I have to use MS Access in a remote location nearly ten miles from the servers where the database is stored.
Here are some of my impressions:
- I am under the impression that the connection between the two locations is a dedication t-line.
- I believe Access works by constantly updating the database, making adjustments as soon as you stop typing.
Here is the issue:
I think these two things, how Access updates the database and the remote location, are leading to a good deal of lagging while using Access. I will type an entry, then look to my paperwork to see what next I need to do, then find that Access won't let me type again for as long as 20 or 30 seconds. I can trick Access to not update the database by tapping spacebar while I look at my paperwork, then delete the spaces and continue, making it like I was typing the whole time.
Here are some things that I think would work conceptually, but I do not know how to do it:
- If I could set Access to only add new information periodically, instead of immediately after typing. Once per day would be enough, because new entries from the remote location are few.
- If I could have two Access databases, one at the remote location and one at the other, and edit the remote database as needed then some auto-protocol reconciles and merges them at the end of the day.
I am certainly open to other solutions. I would entertain using other programs, but I doubt my employers would.
A note on the version I am using: I am using Access 2007, but the tech department told me that the database is a 2003 version and I am some how able to use it with 2007 because of some smart dll editing. I am under the impression that some users, at other locations, are still on 2003, hence the monkey work. My supervisor tells me that if we can resolve some other issues, then they will update all other locations to 2007, so lets just assume that there is no weird dll editing or whatever and say I need a solution with Access 2007.
I apologize if this is off-topic and would appreciate a migration if it is on-topic on a different SE site.
I am not really sure of the best title for this question, but I invite editing to make it better.