Hwo to find the right workgroup .mdw on access2003

[JuniorExcel]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tableau Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hi all!
I am not an expert regarding the security on access 2003. I can log to 2 access2003 database ( our computers are in network).Each time I want to open a specific database, I join the right workgroup.
I've created my own database (just in order to "master" access) on my desktop, but I don't know the name and the location of the default workgroup associated to that database. So , I can access the other database but when I try to open my own database I am rejected.

I tried to find it by searching *.mdw on the (c, but the search returned nothing.

Do you know how to recover or find the right name?

Thank you

 

[apr pillai]

Do the following to find out the location and filename of the active Workgroup Information file:

1. Open the Database.
2. Display the VBA Editing Window (ALT+F11).
3. Press CTRL+G to display the Debugging Window (Immediate Window).
4. Type the following Command and press Enter Key to display the workgroup information file location.

? DbEngine.SystemDB

? Currentdb.Name - will display the active database's pathname.

You need to Run the Workgroup Administration Program WrkgAdm.exe to Join a different workgroup information file.

You will find more details on Microsoft Access Security at this link: Microsoft Access Security.

 

[JuniorExcel]

Do the following to find out the location and filename of the active Workgroup Information file:

1. Open the Database.
2. Display the VBA Editing Window (ALT+F11).
3. Press CTRL+G to display the Debugging Window (Immediate Window).
4. Type the following Command and press Enter Key to display the workgroup information file location.

? DbEngine.SystemDB

? Currentdb.Name - will display the active database's pathname.

You need to Run the Workgroup Administration Program WrkgAdm.exe to Join a different workgroup information file.

You will find more details on Microsoft Access Security at this link: Microsoft Access Security.

Hi Apr Pillai, Thanks for your reply

First, I opened one of the database (A) I have access too, and followed all the steps you described above. That returned me the workgroup information file location.

Secondly I opened my personal database on my desktop and typed the loggin and the password I have been given for the workgroup of database (A)è I managed to log into my personal Database (When I go through the workgroup administration I can visualize all the persons and their rights).

The Microsoft Access Security link you gave me, is very interesting, but I must admit that database securing is complicated on ACCESS.

As I am not an Administrator on my Laptop, I am going to do some researches on how to find run the wrkgadm.exe and what’s its purpose exactly?