Question for Joan (or anyone with knowledge of security)

[Guest]

Hi Joan,

I'm trying to test installing security once more, using Access 2000.

I followed the steps from your web-site and created a new workgroup file,
gave it a unique name (not system, not the same as any database) and saved it
on the C: drive in a separate folder.

I've completed step 5. (Open Access, canceling the opening dialog).

Should there be an LDB file in the folder where I saved the NEW workgroup
file at this point?

When I run wrkgadm.exe, it tells me that I am joined to the new workgroup
file I created.
When I do a search for *.LDB, I get a system.ldb file in the following folder:
C:\Program Files\Common Files\System\ .

I'm somewhat concerned that maybe something is screwed up on my desktop, and
if I go ahead with rest of the steps, it will create users in system.mdw
instead of the new file, similar to what happened last time.

Is there a way to check the current MDW file I'm joined to, other than
running "wrkgadm.exe"?

Would it help to re-install MS Access on my desktop?

Thanks for your response.

-Amit

 

[Scott McDaniel]

You can check for the current workgroup by typing this in the immediate
window:

?DBEngine.Systemdb

How are you opening the database? If you are indeed joined to the new
workgroup, then the command above will let you know

 

[Joan Wild]

Hi Joan,

I'm trying to test installing security once more, using Access 2000.

I followed the steps from your web-site and created a new workgroup
file, gave it a unique name (not system, not the same as any
database) and saved it on the C: drive in a separate folder.

I've completed step 5. (Open Access, canceling the opening dialog).

Should there be an LDB file in the folder where I saved the NEW
workgroup file at this point?

I don't think so. It isn't until you actually open a database that the ldb
file will show in the the folder.

Is there a way to check the current MDW file I'm joined to, other than
running "wrkgadm.exe"?\

Open a database and then check where the ldb is.

 

[Guest]

I don't think so. It isn't until you actually open a database that the ldb
file will show in the the folder.



Open a database and then check where the ldb is.

I did that, and the LDB file shows up in the C:\Program Files\Common
Files\System\ folder, while the wrkgadm.exe tells me that I am joined to the
new workgroup file I created. Interestingly enough, there is no LDB file
created for the new workgroup file.

This definitely means that something is screwed up on my desktop.

I also checked this at my home computer (MS Access 2K, Windows ME), and
following the same steps, the LDB file is created in the new folder with the
same name as the new workgroup file.

I'll have to re-install MS Access on my desktop and take it from there.

Thanks, Joan.

-Amit

 

[Guest]

You can check for the current workgroup by typing this in the immediate
window:

?DBEngine.Systemdb

How are you opening the database? If you are indeed joined to the new
workgroup, then the command above will let you know

Hi Scott,

Thanks for your response.
When I run ?dbengine.systemdb AFTER joining the new workgroup file, it tells
me that the current workgroup file is C:\Program Files\Common
Files\System\System.mdw

So, there is discrepancy in wrkgadm.exe and ?dbengine.systemdb when there
shouldn't be.

I'm having MS Access re-installed on my desktop and see if that makes any
difference.

I also have MS Access 97 installed on my desktop too, but haven't used it in
a long time. Not sure if that fits in somewhere in this puzzle.

To answer your other question, I'm opening the database by starting MS
Access, then using File--> Open. I'm still at step 5 from Joan Wild's steps
to install security.

Cheers,

-Amit

 

[Joan Wild]

You could always create a desktop shortcut to specify the workgroup file to
use...

"C:\path to msaccess.exe" /wrkgrp "path to mdw"

 

[Guest]

You could always create a desktop shortcut to specify the workgroup file to
use...

"C:\path to msaccess.exe" /wrkgrp "path to mdw"

That's a thought. Let me try that and see if I can continue with the rest of
the steps to install security.

Thanks.

-Amit

 

[Guest]

You could always create a desktop shortcut to specify the workgroup file to
use...

"C:\path to msaccess.exe" /wrkgrp "path to mdw"

That worked!!!!

Also, there _is_ an LDB file created with the same name as the workgroup
file I'm joined to, with just MS Access open and no database file open.

Thanks, Joan. You saved the day.

-Amit