Specifying a workgroup file to use from a shortcut

[davewhite04]

Hey all,

I was wondering if any of you guys know how to specify a custom workgroup file in a shortcut to my database.

This is what I've got in my shortcut:

C:\TEST\TEST.mdb /w "C:\TEST\SECURITYFILE.MDW"

Basically I want access's system.mdw to remain the default mdw for access but want my mdb to use a different mdw.

Many thanks!

 

[boblarson]

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Test1\Test.mdb" /WRKGRP "C:\Test\Security.mdw"

 

[davewhite04]

Hi Bob,

I've tried this but Access continues to use the system.mdw rather than the one specified in the shortcut...

I'm using Access 2002, not sure if that might cause a problem...

Thanks for your speedy response!

 

[boblarson]

And you are absolutely sure that you got the database secured properly? I know if I use the wizard to secure my databases, it will give me the option of having Access itself create the shortcut and, what I gave you was the results of that.

Here's a link that might help.
http://www.databasedev.co.uk/access_security.html

 

[davewhite04]

Thanks Bob.

I decided to give the wizard a blast this is what happens.

It seems to use the new mdw file that is created but when I look at what the current mdw in use is (after I've logged on) it says it's the default Access one... strange.

Also if I access the database objects from a new db(link tables for example) it doesn't prompt me for any logging details even though my database has been secured via the wizard.

This is strange indeed.

 

[davewhite04]

Hey Bob,

I have managed to sort it.

The problem was that a user in the new mdw file the wizard creates was also in the Access default mdw file.

What is confusing is that once I login from the shortcut successfully Access still tells me it's using the default security file, this however doesn't compromise the security of my mdb though.

Thanks for your help.