Help with moving secured database

[Sewagerat]

I have made a database and installed a User Level Security wizard on it. It works fine on my computer but I need to transport it to another one. When I did this it did not even ask me to enter User and Password but just rejected me.

Can anyone help me please?

 

[RainLover]

You need to use the appropiate shortcut to open it.

You also need to copy the MDW file as well.

Copy them from the other machine and it should work.

 

[ghudson]

Let's hope you did not alter your computers default System.mdw file. ;-)

 

[Guus2005]

Let's hope you did not alter your computers default System.mdw file. ;-)

In case you did: Copy the system.mdw file from your computer, rename it and place it on the other computer.
Copy the system.mdw from the other computer to your own computer to restore security settings.

The system.mdw file is the default Access uses to open databases. The system.mdw file is the same for a certain office version and perhaps all office versions thus enabling you to open any unsecured database.

You open a secured database not just by double clicking but you use a shortcut instead. Typically:

C:\program files\Office\MSAccess.exe /wrkgrp c:\somedir\MyWorkGroup.mdw c:\somedir\SomeApplication.mdb

Enjoy!