Hi There,

Just a quick question. Anytime I've secured a database I've always used the option that creates a shortcut file and the DB will get accessed that way.

The other option is to make the mdb. file the Default and access the DB through that file directly.

I'd like to do just that, does anyone know if this is a good/bad idea? is it safe to set it up like this so that Users are not using a shortcut file?

Thanks

I'm not sure I follow the logic - When you secure your db you create a shortcut- ? You can create a short cut to a .mdb that is not 'secured'. ? Do you mean that in your shortcut in the command line you reference the .mdw file you want the .mdb to use when it opens?

I'm not sure I follow the logic - When you secure your db you create a shortcut- ? You can create a short cut to a .mdb that is not 'secured'. ? Do you mean that in your shortcut in the command line you reference the .mdw file you want the .mdb to use when it opens?

Or maybe he means he creates an mde (compiled) file for the users to use?

It's when following the security wizard it asks if "I want to make this my default workgroup info file" or "I want to create a shortcut to open my Security enhanced database"

I was under the inpression that instead of using the shortcut file to open the DB I could double click the secure mdb. file to open the DB and enter whichever passwords.

I may have this figured wrong...

When I select the latter, There is no short cut, and I access the DB through the mdb.

What's your views?

Paul