Using database with userlevel security

[Lutz Uhlmann]

HI,

I had set up userlevel security on my database in Access 2000. Since my
hard disk crashed, I have reinstalled XP and MSO. I do have a full backup
of my old system. I have also recorded the Personal ID of each user
created.

Right now, I am unable to open my database since they have been secured
with user level id and password. Could you help me with how to proceed
with this situation? I ll be grateful even if I can simply get the data
out without the security structure.

Do you have a backup of your old MDW (system.mdw) ???

Lutz

 

[Ramesh]

HI,

I had set up userlevel security on my database in Access 2000. Since my
hard disk crashed, I have reinstalled XP and MSO. I do have a full backup
of my old system. I have also recorded the Personal ID of each user
created.

Right now, I am unable to open my database since they have been secured with
user level id and password. Could you help me with how to proceed with this
situation? I ll be grateful even if I can simply get the data out without
the security structure.

Thanks for any help.
Ramesh

 

[Ramesh]

Yes I do.

Is there a way I can use this file to restore status quo?

Ramesh

 

[Lutz Uhlmann]

Yes I do.

Is there a way I can use this file to restore status quo?

Two ways ...

First way

Replace the system-wide MDW with your backup
-> C:\WINDOWS\system32\sytem.mdw

or the
Second way (the way i prefer)

Use one MDW for each project. You can tell Access which one to use with the
/wrkgrp parameter ...

start "MyDatabase" "C:\Programme\MicrosoftOffice00\Office\MSACCESS.EXE"
C:\Project\0815\program.mdb /wrkgrp C:\Project\0815\sec\program_sec.mdw
/user "User1" /pwd "pass123"

Lutz

 

[Lutz Uhlmann]

Two ways ...

First way

Replace the system-wide MDW with your backup
-> C:\WINDOWS\system32\sytem.mdw

STOP ... Access 2000 has maybe another path.
with trying this in Access 2000
Debug.Print DbEngine.SystemDB
you get the actual system-db

But you should be careful! If you use the actual system.mdw already in other
projects you should backup it.
Because of this i use the second way

Lutz

 

[Ramesh]

Thanks Lutz. The second method worked just fine. Only I didnt have the
system.mdw in the system32 folder. It was in the Common files/system
folder. Plus in any case the security info was in another mdw called
Secured.mdw which was in the same folder as the mdb file. Tried your common
line and it worked simply well.

Now to be a bit greedy. Is there a short way I can open the mdb without the
full command line? I have a few other mdbs also used with the same mdw. Or
is there a way to strip the mdb of the security info?

Thanks very much. You have more than saved my situation. I am only seeking
some bonus.

Ramesh

 

[Lutz Uhlmann]

Thanks Lutz. The second method worked just fine. Only I didnt have the
system.mdw in the system32 folder. It was in the Common files/system
folder. Plus in any case the security info was in another mdw called
Secured.mdw which was in the same folder as the mdb file. Tried your
common line and it worked simply well.

Yes i know. I have 97, 2000 and 2003 on my pc, so i told you the wrong path.
Do you only use Access 2000?

Now to be a bit greedy. Is there a short way I can open the mdb without
the full command line? I have a few other mdbs also used with the same
mdw. Or is there a way to strip the mdb of the security info?

Do you use this MDW for every MDB on your pc???
If yes then you can rename your MDW to system.mdw and copy it to the Common
files/system folder as new system-wide access security. You can also use a
tool called WRKGADM.EXE to set the new security-mdw.

If no then use batch-files to start your MDBs with the common MDW or add a
Windows Explorer context-menu (google) for starting MDBs with security.

Thanks very much. You have more than saved my situation. I am only
seeking some bonus.

No prob

Lutz

 

[Ramesh]

Thanks again Lutz. Very useful info indeed.

Ramesh