IGNORE SECURITY!

[Dave180]

Chris O'C wrote (a while back)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Access user level security is *always* on. Whatever workgroup (mdw file)
you're joined to when you open *any* Jet db file, if the admin user has a
password assigned, you'll be prompted for your user name and password.

Join an unsecured workgroup on your pc. The default system.mdw file
shouldn't have an admin password assigned, so you won't be prompted.

Chris
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I joined a new worgroup file on my NEW (MSA 2003) MDB.
It starts with MSA hidden and only one form (Window) open. Chris's solution
works great with this App - since it now hides the MSA User Signon panel,
which was not required.
However, as expected, all my other DBs on the same machine (or at least
every one I open as the session user) have joined the new workgroup. I need
security on all DBs except the new one.
When I distribute the new Db I wont know what security the end user will
have on their systems.
How best to overcome this please? Can the workgroup be assigned
programatically through a shortcut lnk? If so how please?

Regards,
Dave.

 

[Dave180]

Thanks for the reply Chris,

Can either be done programatically?
I should know the SECURE DB users (and their environments etc)
But I won't know whats on the NEW Db systems.

I'll assume that MSA can't cope with this - since it uses Session Names for
Security.
This data will have been predetermnined before MSA is run (no matter what
the DB)

Can you suggest a tool that will create the LNK code requirements as your
suggestion?

My NEW DB CANNOT have security implemented (I won't know if MSA is even
installed on those machines)
My other distributables (using 2003) require ULS to present the correct
start-up options etc.

Is this a brick wall that won't be resolved without recourse to another
development tool?

Dave