Different passwords in Access 2007

[Emmchen]

I'm wondering if there in Access 2007 exists a possibility to, after having
split a database into a "tables only " part and a "forms" part, set different
passwords for the different parts of the database?

I would like to have an "administrator" password for the "tables only" part
and a "user" password for the "forms" part. However, when I use the password
function in Access 2007 and set different passwords, I cannot use my "user"
database, it just states that I don't have the proper password whenever I try
to open a form.

So... is there a way to actually set different passwords in Access 2007? If
not, why?

 

[Joan Wild]

Yes you can do this.

After setting the password on the backend, open the frontend and delete the
table links. Then recreate them. When it creates the new links, you'll be
prompted for the backend password which will be stored in the links.

 

[Emmchen]

I tried this, but I am not sure I understood correctly. I had a database
without a password. Then I split it into a backend and a frontend. Then I
gave the backend a password. Then I opened the frontend and deleted the table
links.

But, then I don't know how to recreate the links...? And when I do - did you
mean that I would then be able to set a password for the frontend separate
from that of the backend?

 

[Joan Wild]

But, then I don't know how to recreate the links...? And when I do - did
you
mean that I would then be able to set a password for the frontend separate
from that of the backend?

Go to File, Get External Data, Link Tables and navigate to the backend.
Select the tables, and when you click OK, you'll be prompted for the backend
password.

And yes, you can then set a different password for the frontend.

 

[Emmchen]

Thank you! It seems to have worked!
/Emma

Go to File, Get External Data, Link Tables and navigate to the backend.
Select the tables, and when you click OK, you'll be prompted for the backend
password.

And yes, you can then set a different password for the frontend.

 

[JJ]

thanx joan wild. i was googling and found the right path at here, excellent
idea to protect both be as well as fe.