Mapping a drive when Starting Access

[Steve]

I have placed an application on our dept's shared drive 's:\' , but I have to
map the drive before Access can open it. Is there some startup code I can use
to do that automatically? Also, I haven't split the database since going
through Citrix seems to be faster than a front-end/back-end strategy.
Thanks for your help.

 

[pietlinden]

I have placed an application on our dept's shared drive 's:\' , but I have to
map the drive before Access can open it. Is there some startup code I canuse
to do that automatically?  Also, I haven't split the database since going
through Citrix seems to be faster than a front-end/back-end strategy.
Thanks for your help.

you could always use the absolute path to the file, e.g.,

\\servername\directory\filename

or you could no doubt get some code from Randy Birch that maps a
network drive.... www.mvps.org/vbnet
yep... it's there. be warned, though. You may need to tweak the VB a
little bit, since VBA (unlike VB6) does not allow control arrays...
once you fix that part, you should be good to go.

 

[Brian]

Here is a poor man's solution: make a batch file that would first maps the
drive then opens the app, and have the user run the batch file. It should
look something like this:

net use S: /delete
net use S: \\MyServer\MyAppFolder
"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "S:\MyApp.mdb"

However, I'm not entirely clear on how you are having the users open the
app. Am I correct in inferring that the clients will all run this app in a
Citrix session? If so, I would probably make a logon script for the Citrix
session that maps the S: drive there rather than using a batch file.

Net use can also be used to