Different passwords in Access 2007

11 Nov 2008 8:55 AM

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?

11 Nov 2008 2:53 PM

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.

--
Joan Wild
Microsoft Access MVP

Show quoteHide quote

"Emmchen" <Emmc***@discussions.microsoft.com> wrote in message
news:9DFFE3F8-A042-4045-A2B6-E6DD609395BB@microsoft.com...
> 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?

11 Nov 2008 4:23 PM

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?

Show quoteHide quote

"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" <Emmc***@discussions.microsoft.com> wrote in message
> news:9DFFE3F8-A042-4045-A2B6-E6DD609395BB@microsoft.com...
> > 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?
>
>

11 Nov 2008 5:07 PM

Joan Wild

"Emmchen" <Emmc***@discussions.microsoft.com> wrote in message
news:8AECE099-9744-4FC5-A88D-1B87C84B09D1@microsoft.com...
>
> 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

12 Nov 2008 8:34 AM

Emmchen

Thank you! It seems to have worked!
/Emma

Show quoteHide quote

"Joan Wild" wrote:

> "Emmchen" <Emmc***@discussions.microsoft.com> wrote in message
> news:8AECE099-9744-4FC5-A88D-1B87C84B09D1@microsoft.com...
> >
> > 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
>
>

20 Nov 2008 10:51 AM

JJ

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

Show quoteHide quote

"Emmchen" wrote:

> Thank you! It seems to have worked!
> /Emma
>
> "Joan Wild" wrote:
>
> > "Emmchen" <Emmc***@discussions.microsoft.com> wrote in message
> > news:8AECE099-9744-4FC5-A88D-1B87C84B09D1@microsoft.com...
> > >
> > > 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
> >
> >

Thread options