Different passwords in Access 2007

  • Thread starter Thread starter Emmchen
  • Start date Start date
E

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?
 
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.
 
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?
 
Emmchen said:
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?
Click to expand...

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.
 
Thank you! It seems to have worked!
/Emma

Joan Wild said:
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.
Click to expand...
 
thanx joan wild. i was googling and found the right path at here, excellent
idea to protect both be as well as fe.
 
Back
Top