Thanks for the reply and that was my gut feeling.
I saw replication on your list. Is it possible to run the database locally and have a close event sync the data up to the table on the vpn share? Not sure how it would handle the same record being updated by more then one person though.
Hello,
I have a small access database I am putting out on a network share for myself and others to use. When I open it it can take a minute to do anything. I click on a form about 80 seconds later it opens. Query is nearly the same. I tried to do a split and it made it worse by at least...