Connecting To Networked Files

[iheartvba]

Hi,
I have a MS Access Database which connects to a separate MS Access back end. The back end is located on a network drive on a peer-to-peer network, if the computer with the back end or front end is restarted, then the users have to double click and open the network drive, i.e. they have to go the network drive e.g. Z:\ in My Computer and double click on the drive to open it, only then Access is allowed to link to the back end. This is pretty easy, but a lot of our older staff find it difficult, so I would like some way to do this automatically, or programmaticall y via Access.

Thanks

[DonRayner]

When the backend computer is rebooted the maped drives on the workstations loose their connection because the backend computer has severed it. Either rebooting the workstation or just opening the connection will restore it.

I beleive that if you use the full UNC path instead of a mapped drive to link your tables, that you will no longer have this problem. IE: instead of using.

Z:\MyDatabase.mdb

use this

\\ComputerName\ShareName\PathToDb\MyDatabase.mdb

BTW, if you are using a non-server version of window to act as your backend, you will be limited to 10 concurrent connections.

[iheartvba]

Hi DonRayner,
Thanks a lot for the advice regarding changing the Mapped Drive path to a network path, that will really be useful.

P.S. I am slowly starting to understand the uses of a Server version of Windows and probably will invest in one some time next year, but we don't have I.T. staff at work, really I am quite hesitant to move to a server system because it would be more difficult to administer than a peer - to - peer network, but I think it will be nessecary as we grow, and move to a more paper less office. Peer- to Peer networking is highly unsecure, I basically can't put any documents on the network that I don't want staff to see.

[DonRayner]

Glad I could help.

Don