Creating an mde file from a secured database

[Guest]

Help please!

I have a database that I have spilt, using the database splitter. Then I
ran the security wizard to add user-level security for the database. I am
the administrator. I then logged onto the database through the shortcut so
that I am using the new workgroup file. I then ran the create .mde file.
Even though all the books I have say that the .mde will retain the security
from the original database, for whatever reason the .mde is using the
system.mdw file that is on my hard drive. The .mde is not being created to
use the workgroup file that I created for the database.

Any ideas about what I'm doing wrong or suggestions on how to fix this?

Thanks,
Lesli

 

[david epsom dot com dot au]

It looks like the original database is not correctly
secured either. Can you get into the original database
using system.mdw file?

(david)

 

[TC]

Rudely hopping in here (cos I can not see the OP's post)

OP, you misunderstand the relationship between the database & the
workgroup file.

An mde or mdb database file does not know, in any way shape or form,
the name or location of the workgroup file that you created for it.

You must /tell/ Access which workgroup file to use, when you open that
database.

A common way of telling it that, is to start the database via a
shortcut of the following form:

(all on one line)

"full path to MSACCESS.EXE"
"full path to MDB or MDE file"
/wrkgrp "full path to MDW file"

Access then uses whatever workgroup file you tell it to, via the
/wrkgrp switch. Access /does not/ examine the MDB or MDE file to
determine (automagically) which workgroup file it should use.

HTH,
TC

 

[Guest]

EXCELLENT!!! That solved my problem. I was wondering if I needed to do
something like that but I couldn't figure out quite what to do.

Thanks for you help.

Lesli