If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using database with userlevel security
"Ramesh" ramborums@yahoodotcom schrieb im Newsbeitrag ... 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 |
#2
|
|||
|
|||
Using database with userlevel security
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 |
#3
|
|||
|
|||
Using database with userlevel security
Yes I do.
Is there a way I can use this file to restore status quo? Ramesh "Lutz Uhlmann" wrote in message ... "Ramesh" ramborums@yahoodotcom schrieb im Newsbeitrag ... 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 |
#4
|
|||
|
|||
Using database with userlevel security
"Ramesh" ramborums@yahoodotcom schrieb im Newsbeitrag ... 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.EX E" C:\Project\0815\program.mdb /wrkgrp C:\Project\0815\sec\program_sec.mdw /user "User1" /pwd "pass123" Lutz |
#5
|
|||
|
|||
Using database with userlevel security
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 |
#6
|
|||
|
|||
Using database with userlevel security
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" wrote in message ... 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 |
#7
|
|||
|
|||
Using database with userlevel security
"Ramesh" ramborums@yahoodotcom schrieb im Newsbeitrag
... 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 |
#8
|
|||
|
|||
Using database with userlevel security
Thanks again Lutz. Very useful info indeed.
Ramesh "Lutz Uhlmann" wrote in message ... "Ramesh" ramborums@yahoodotcom schrieb im Newsbeitrag ... 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 |
Thread Tools | |
Display Modes | |
|
|