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.

--
Joan Wild
Microsoft Access MVP
"Emmchen" <(E-Mail Removed)> wrote in message
news:9DFFE3F8-A042-4045-A2B6-(E-Mail Removed)...
> 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?

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" wrote:

> 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.
>
> --
> Joan Wild
> Microsoft Access MVP
> "Emmchen" <(E-Mail Removed)> wrote in message
> news:9DFFE3F8-A042-4045-A2B6-(E-Mail Removed)...
> > 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?
>
>

"Emmchen" <(E-Mail Removed)> wrote in message
news:8AECE099-9744-4FC5-A88D-(E-Mail Removed)...
>
> 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.


--
Joan Wild
Microsoft Access MVP

Thank you! It seems to have worked!
/Emma

"Joan Wild" wrote:

> "Emmchen" <(E-Mail Removed)> wrote in message
> news:8AECE099-9744-4FC5-A88D-(E-Mail Removed)...
> >
> > 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.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>

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

"Emmchen" wrote:

> Thank you! It seems to have worked!
> /Emma
>
> "Joan Wild" wrote:
>
> > "Emmchen" <(E-Mail Removed)> wrote in message
> > news:8AECE099-9744-4FC5-A88D-(E-Mail Removed)...
> > >
> > > 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.
> >
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> >
> >