User Password to protect my design Access2007 database.

[yiotaa]

I have a multiuser database in MSAccess 2007 and I would like to have
password in order to protect my database design.
Please help me!

 

[Tom van Stiphout]

On Mon, 20 Oct 2008 02:30:01 -0700, yiotaa

Assuming you mean the A2007 ACCDB format, that is not possible. Also
keep in mind that even though in some cases the application can be
yours (and your clients are licensing usage), the data is not. If you
were able to hide the db design, you would likely also hide the data
and that's a big no no in many jurisdictions.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

I have a multiuser database in MSAccess 2007 and I would like to have
password in order to protect my database design.
Please help me!

If you want to keep the users from seeing your code or modifying the structure
of forms and reports, make your .mdb or .accdb file into a .mde or .accde and
distribute that. KEEP A COPY of the original, you'll need it to make
modifications.

There is no really solid security structure in 2007. You can make it a hassle
for users or hackers, but any password can be cracked if someone is
determined.