I have vpn access to a server where the database lies.
I can start up unsecured mdbs no problem.
But how do I create the shortcut to start the secured mdb?
The setup is:
server: \\servername\foldername\mdbfile.mdb
wrkp: \\servername\foldername\secured.mdw
I'm trying to use:
\\servername\foldername\mdbfile.mdb /USER myusername /WRKGRP "Secured.mdw"
\\servername\foldername\mdbfile.mdb /USER myusername /WRKGRP
"\\servername\foldername\Secured.mdw"
but can't get it to work. Any ideas?

Signature
Jesper Fj?lner
Denmark
Douglas J. Steele - 16 Apr 2005 16:21 GMT
For any startup parameters to be recognized, the shortcut must include the
full path to the Access executable:
"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
"\\servername\foldername\mdbfile.mdb" /USER myusername /WRKGRP
"\\servername\foldername\Secured.mdw"

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
>I have vpn access to a server where the database lies.
> I can start up unsecured mdbs no problem.
[quoted text clipped - 10 lines]
>
> but can't get it to work. Any ideas?
Christopher Glaeser - 19 Apr 2005 00:58 GMT
> Any ideas?
I don't know if this will help in your situation, but an alternative to
running Access over VPN is to use Remote Login over VPN. I was having
problems running QuickBooks over VPN, so I started using Windows Remote
Login to run QuickBooks on the remote computer, and now I also use it for
Access too. If the VPN connection should drop or gets slow, it will not
affect QuickBooks or Access or other applications that are running. Just
log back in if it drops and the applicatinos are still running. This
assumes, of course, that you are running XP Pro on a remote computer.
Best,
Christopher
Jesper Fjølner - 19 Apr 2005 11:43 GMT
Thanks both of you. I got it working when I corrected the shortcuts to
include the access executable.
It's running a bit slow but sufficient to do updates on the database.

Signature
Jesper Fjølner
Denmark