Question for Joan (or anyone with knowledge of security)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Amit said:
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?
Click to expand...

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"?\
Click to expand...

Open a database and then check where the ldb is.
 
Joan Wild said:
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.
Click to expand...

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
 
Scott McDaniel said:
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
Click to expand...

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
 
You could always create a desktop shortcut to specify the workgroup file to
use...

"C:\path to msaccess.exe" /wrkgrp "path to mdw"
 
Joan Wild said:
You could always create a desktop shortcut to specify the workgroup file to
use...

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

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
 
Joan Wild said:
You could always create a desktop shortcut to specify the workgroup file to
use...

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

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
 
Back
Top