Refresh network connection / link?

[m.cringle]

When I log into my database in the mornings, using a dedicated link for
my user level security, it usually fails to open the database. I
receive an error message something along the lines of 'unable to locate
requested file'.

My database is located on a network drive - all I do is open the file
which contains my database and it all works again fine.

It's not a huge problem but I'm about to roll this out to about 30 / 40
colleagues and it would be great (and more professional) if they did
not have to go through this procedure every morning!

Any ideas?

 

[Arvin Meyer [MVP]]

First, it is important that you split your database, and put each front-end
on the user's workstation. Never share a front-end unless you want to
eventually corrupt it. Link the front-ends to a shared data source on the
server.

Your problem may be that the network mapping is not persistent. That's
something you'll need to work out with your network administrator, if you
don't have rights to fix it.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[m.cringle]

Thanks Arvin - I will look into that

First, it is important that you split your database, and put each front-end
on the user's workstation. Never share a front-end unless you want to
eventually corrupt it. Link the front-ends to a shared data source on the
server.

Your problem may be that the network mapping is not persistent. That's
something you'll need to work out with your network administrator, if you
don't have rights to fix it.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com