Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening Access DB via VPN Almost Always Corrupts DB 1

Status
Not open for further replies.

RobertIngles

Technical User
Jan 20, 2011
113
CA
I really don't know if there is a solution to this other than not doing it.

I recently started opening my Access DB (on a shared network drive) via VPN because I work from home so often.

It seems that pretty much every second time I open the DB, I get a message that the VB modules have been corrupted and that it can only be opened if the VBA project is deleted. Is it possible that when I close the DB remotely it is not closing properly on the shared drive?

Does anyone know if there is a solution for this? I try to make sure that I only leave the DB open for what I need and close it immediatly after because I am paranoid about my VPN disconnecting and leaving the DB in an unstable state however even when taking this precaution I am having problems.

The only solution I can think of is to go back to copying the DB to my HD before leaving work, working with it at home and then copying it back to the shared drive each morning. Not a very elegant solution as I end up with a folder full of re-named previous versions (I always copy the previous day's DB into an archive folder before reloading the one I worked on last evening.

Any information or suggestions would be appreciated!

Thanks
Robert
 
No Access database should be opened on a network drive, VPN or not. Bottom line, No ands, ifs, or buts. The database should be split with a front end (forms, reports, queries, code) copy on your local computer and all other users local computer. Only the tables should be on the backend and linked to your front end. I VPN in daily along with many other users and never have corruption.
 
Thanks MajP!

Do I have to take any precautions to convert the DB to this setup? I am thinking that I would just create a link to my tables (on the network drive) to local drive? I'm hoping it's that simple :)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top