Workgroup Information File

Can anyone tell me where the DB owner info lives in the MDB file?

Points value Modified

HELLO IS THERE ANYBODY THERE :-(

I Dont have any more points. Cmon

Have U tried using the Wrkgadm utility? U will find this in the Office folder at
..\Microsoft Office\Office\1033 or whatever.
Search for 'Wrkgadm.exe'. I dont know if you can get into an MS Access db without System.mdw, but you sure can create one with this utility (or even join an existing one).
Try it and let me know if it works. ;-)

I know someone who had this happen. They created a new workgroup and dummy DB, then made a copy of system.mda and then placed it in the location of the original. This allowed the DB to be opened and the file modified to reflect the correct settings.

Good luck!

Re-create the MDA file or recover the *.MDA files with the custom add-ins and then re-add- your *.MDA file through the ADD-IN MANAGER you do to get your *.MDB to use the *.MDA files.

Good Luck!!

Re-create the MDA file or recover the *.MDA files with the custom add-ins and then re-add- your *.MDA file through the ADD-IN MANAGER in your *.MDB file.

Good Luck!!

go to start run type wrkgadm and press ok (its located in c:\windows\system\) and click create.
create a new workgroup file.
if you have the workgroup id number that you used to create the first one then give that workgroup ID to wrkgadm.exe.
if you did not create that file then it was the default and dont give any workgroup ID.
hope it works

Right-click the Windows desktop,choose New from the shortcut menu,and then click shortcut
In the create Shortcut wizard,type the path to MSACCESS.EXE The default location is C:\Programs Files\Microsoft Office\Office\MSAccess.exe
At the end of the path to MSACCESS.EXE,type the /User and/Pwd switches with Admin as the user and whatever password you use for the Admin
'c:\Program Files\Microsoft Office\MSAccess.exe/User Admin/Pwd x'
click next
On the Shortcut Name screen,type Access as Admin and click finish
Related KB article Q198895

If you haven't used the "Workgroup Administrator" to change\create this file then you were using the default one which is created when MSAccess is installed. In this case you just need to re-install MSAccess and you should be bale to access your MDB file.

Otherwise, if you have used the "Workgroup Administrator" to create a new file, then you have to run the "Workgroup Administrator" again, typing the same case-sensitive name, organization, and workgroup ID entries you used when you originally created it.

Hope this helps you out,

Rafik El-Raheb.

If you are willing you can e-mail me your MDB files and you MD* files and I can try it for you. I have never had this happen to me but I have had luck rebuilding access info on apps I have written.

Shawn Burt
Bank of Whitman

burtsa@bankofwhitman.com

An .mda file isn't going to help you. You need an .mdw file (but you know that already). Depending on how extensive the *original* .mdw file was customized (e.g., the ownership of the database was passed to another user; ownership of other database items were passed to various users; the original system.mdw was used as a starting point) it may be possible to gain partial access to the database (.mdb) file by creating a new database using system.mdw and importing database objects. Sometimes, transferring the database and object ownerships to a user other than Admin (and removing Admin from the Administrators group) is overlooked.

Admin exists in every .mdw (it can't be deleted) and it is always the same (even if the workgroup info -- including the Workgroup ID -- is different).

Unless all rights are specifically removed from Admin (and Admin removed from the Administrators group) and all rights are similarly removed from the Users group, Admin can always get into an Access database (via import and link) even if Access can't open the database with any available .mdw.

Maity-Boy,here are a couple of programs that may crack the password that could be of use
L0phtCrack:http://www.l0pht.com/
(Note that the second character is a zero)
Also see if this is the key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSetControl\Lsa