Password on front and backend

[SpookiePower]

I have spilt my database in a back- and frontend.

I have put a password on the backend, and it works
just fine. But when I open the frontend and access
the backend, it do not ask for a password. I thought
that it all so would ask for a password, if I used
the frontend to access the backend. How can I get
it to ask for a pasword when using the frontend ??

 

[Joan Wild]

Each mdb (frontend and backend) can have a different password - it's applied
to the file.

When you create the table links to the backend, you are prompted for the
backend password, and it is stored in the table links (and you won't be
asked for the password again).

If you want a password on the frontend as well, then apply it to the
frontend.

 

[robbuonocore]

Each mdb (frontend and backend) can have a different password - it's applied
to the file.

When you create the table links to the backend, you are prompted for the
backend password, and it is stored in the table links (and you won't be
asked for the password again).

If you want a password on the frontend as well, then apply it to the
frontend.

--
Joan Wild






- Show quoted text -

Does the password on the backend have to be set first? I can't link
to table in a password protected database. I get a message, Invaild
Password and am never actually prompted for the password. I was using
linked table manager.

Robby

 

[Joan Wild]

Does the password on the backend have to be set first? I can't link
to table in a password protected database. I get a message, Invaild
Password and am never actually prompted for the password. I was using
linked table manager.

You need to set the password on the backend first. Then open the frontend,
delete the current table links, and recreate them using File, Get External
Data, Link. This will prompt you for the backend password, which will be
stored with the link. After this, you'll be able to use the Linked Table
Manager.