Access 2010 on Mapped Drive

[Dartagnan]

Has anyone else experienced the following?

My DB is on a network/mapped drive. I open the DB using a shortcut on my desktop. All is good until my computer goes to sleep. When I come out of sleep I try to work in the DB again and I get a reserved error (-5500). If I close and reopen the DB opens in read-only and wants me to do a Save As. I also notice the laccdb won't go away and can't be deleted. I must say the sleep seems to disconnect the DB.

Any insight is greatly appreciated.

 

[Montez659]

Sleep mode on a PC can screw so much stuff up. From what I have experienced and researched, it is probably the worst thing you can do and not worth it. I have Win7 and it completely messed up the Aero functionality when waking back up. Sleep is just one of those things that MS hasn't got right.

It'd be better to just "Shut 'er down"

 

[boblarson]

The database needs to be split and the BACKEND (tables only) is on the file server (network/mapped drive) but the FRONTEND (everything else) should be a COPY on EACH USER'S COMPUTER.

 

[Montez659]

That too.

Plus, after you split, make sure that the path to the back end is not through the mapped drive but the actual server path. I have run into problems with users losing their mapped drive, and thus connectivity to the back end.

 

[boblarson]

That too.

Plus, after you split, make sure that the path to the back end is not through the mapped drive but the actual server path. I have run into problems with users losing their mapped drive, and thus connectivity to the back end.

It does depend on the situation though. Where I work we have standard mapped drives so it was helpful to us that we had them linked using the drive letters instead of UNC because the UNC path changed. But that would be a RARE instance, so using UNC is going to be better anyway. And when we moved to Citrix for all of our apps, it actually has worked out better using the UNC path instead as it doesn't have to try to resolve the path.

 

[Dartagnan]

Will give it a try. Wish Access could recover lost connections.

Thank you for the feedback.