Opening Incorrect access file

[Don]

Hello, I have deployed a Access 2003 mde file on Citrix. It's been working
well but today I added another Access 2003 application (which is password
protected) to the Citrix system. When the users click on the icon for the
first mde file it prompts them for the database password, I'm assuming that
it's trying to open the wrong file. I call the file using the full path of
the msaccess.exe file followed by the full path of the mde file. Has anyone
experienced this type of issue when opening an acess file it seems to stick
with a previously opened file?

 

[John Vinson]

Hello, I have deployed a Access 2003 mde file on Citrix. It's been working
well but today I added another Access 2003 application (which is password
protected) to the Citrix system. When the users click on the icon for the
first mde file it prompts them for the database password, I'm assuming that
it's trying to open the wrong file. I call the file using the full path of
the msaccess.exe file followed by the full path of the mde file. Has anyone
experienced this type of issue when opening an acess file it seems to stick
with a previously opened file?

I suspect that it's not the Database that is at fault - it's the
Workgroup file.

Secured databases typically have a custom .MDW workgroup file
distributed with the database; this contains the user and group names.
The default user Admin is typically locked out with no privileges.

In order to use your unsecured database, you need to join the default
SYSTEM.MDW workgroup file, normally stored in Windows\System. You can
use a shortcut to the database with a command line like

"C:\Program Files\Office\MSACCESS.EXE" "D:\SomePath\Yourdatabase.mdb"
/wrkgrp "C:\Windows\System\SYSTEM.MDW"

to open the unsecured database. Change the path and filenames to match
your needs of course.

John W. Vinson[MVP]

 

[Don]

Thanks, I'll try that. What's weird is that after trying to log on four
times it let me onto the unsecured database.