remove user level protection completely from mdb

[Guest]

Hello all,

Question: How do I remove password protection from my mdb COMPLETLY? In
other words, how do I initialize my .mdb (in terms of passwords and
protection) without affecting access to tables, data in tables, forms,
macros, etc...

I had introduced user level protection but it created havoc when other users
tried to use my .mdb as well as other ACCESS data base files, unrelated to my
mdb. I've tried to remove all passwords and all protection from my .mdb, but
it seem somehow somewhere, in a dark corner, there remains some reference to
these password settings.

Your Help is greatly appreciated.

 

[White Bilky]

Hello all,

Question: How do I remove password protection from my mdb COMPLETLY? In
other words, how do I initialize my .mdb (in terms of passwords and
protection) without affecting access to tables, data in tables, forms,
macros, etc...

I had introduced user level protection but it created havoc when other
users tried to use my .mdb as well as other ACCESS data base files,
unrelated to my mdb. I've tried to remove all passwords and all
protection from my .mdb, but it seem somehow somewhere, in a dark
corner, there remains some reference to these password settings.

Your Help is greatly appreciated.

To open up your database, grant full permissions for all objects to the
'Users' group.

Having said that, the 'havoc' you are experiencing may be down to 'mis' use
of the 'mdw' files. Your mdw file should reside in a public place and you
must provide all your users with a shortcut which refers to your mdw in the
command line. Typically, your command line would look like this:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"X:\MyPath\MyGUI.mdb" /wrkgrp "X:\MyPath\MyGUI.mdw"

The default workgroup on your users' PCs should be an unmodified
'system.mdw' which will allow them to open all other non-secured Access
files.

Have a look at the step-by-step guide on my website, it may help.

Regards,
Keith.
www.keithwilby.com

 

[Guest]

Thank you very much. Granting full permission to users group did the job.
Thanks again. By the way, greate web site. Keep up the good work.