backend table password protection

[Lifeseeker]

Hello,

My database has been split successfully, but without password protection.

Knowing that in access 2007 the user-level security option has been disabled by Microsoft, I guess I can aways create a form-based login screen to protect the the front-end.

Now the backend is unprotected and it's on the shared network. So is there any way to add password protection on the backend only? (i.e. person A can view and edt all the back-end tables, and person B can see but not edit, etc)

Is this still possible?

Many thanks

 

[boblarson]

You can encrypt/add a password to the backend. However, if you want to let someone work in it, they will need that password and there is nothing you can really do to keep them from doing anything they want in the backend if they have the password. But to keep users out, you can set a password.

And if you do, you will need to relink your tables and select the save password checkbox when doing so, so that the application can get in when the frontend starts and users won't need to input the password, of which they should not know.

 

[jonathanchye]

You can encrypt/add a password to the backend. However, if you want to let someone work in it, they will need that password and there is nothing you can really do to keep them from doing anything they want in the backend if they have the password. But to keep users out, you can set a password.

And if you do, you will need to relink your tables and select the save password checkbox when doing so, so that the application can get in when the frontend starts and users won't need to input the password, of which they should not know.

Correct me if I am wrong, but by doing so won't it mean that users can't add/edit records at all since they would need to access the table through the FE?

 

[boblarson]

Correct me if I am wrong, but by doing so won't it mean that users can't add/edit records at all since they would need to access the table through the FE?

Okay, I'll correct you because you're wrong. If you link to the backend from the frontend, when you link you will be providing the password (and you check the remember password checkbox) so then when they open and use the frontend it is just like not having the password there for them but if they try to open the backend directly, they can't.

 

[Lifeseeker]

I have put a password on the backend.

How do I relink the frontend tables? When I open the linked table manager, no message box appears. Am I missing something?

Correct me if I am wrong, but by doing so won't it mean that users can't add/edit records at all since they would need to access the table through the FE?

 

[boblarson]

What do you mean that no message box appears? Here are the steps you need to take.

1. Open your FE while holding down the shift key.

2. If on Access 2007 or 2010 make sure that the database is either in a trusted location or that you have clicked the ENABLE button that appears below the Ribbon when opening a database from a non trusted location. Make sure you keep holding the shift key down when clicking it.

3. Go to the tables and delete each linked table that is linked to the backend you just set a password for. As long as you are in the frontend you won't be deleting the table, just the link.

4. Next you go link the tables again but this time be mindful of a checkbox that will appear on the bottom right of the form that opens when you select the tables for linking. Check that Remember Password checkbox.

5. You aren't using Linked Table Manager for any of this.

 

[Lifeseeker]

I think I'm missing the:

4. Next you go link the tables again but this time be mindful of a checkbox that will appear on the bottom right of the form that opens when you select the tables for linking. Check that Remember Password checkbox.

I'm not sure where the link the tables is done. Not done in linked table manager?

What do you mean that no message box appears? Here are the steps you need to take.

1. Open your FE while holding down the shift key.

2. If on Access 2007 or 2010 make sure that the database is either in a trusted location or that you have clicked the ENABLE button that appears below the Ribbon when opening a database from a non trusted location. Make sure you keep holding the shift key down when clicking it.

3. Go to the tables and delete each linked table that is linked to the backend you just set a password for. As long as you are in the frontend you won't be deleting the table, just the link.

4. Next you go link the tables again but this time be mindful of a checkbox that will appear on the bottom right of the form that opens when you select the tables for linking. Check that Remember Password checkbox.

5. You aren't using Linked Table Manager for any of this.

 

[boblarson]

Which version of Access are you using?

 

[Lifeseeker]

Access 2007

Which version of Access are you using?

 

[boblarson]

Sorry, I forgot you said 2007 at first.

To link you go to the EXTERNAL DATA tab on the Ribbon. Then you select ACCESS from the IMPORT group. When the dialog comes up you choose LINK instead of IMPORT. Then browse to the file you want and click ok. It will ask you for the password and then you select the tables you want. I just ran through it so I found there is no checkbox for this one - it isn't necessary for Access, it will remember the password once you've linked after putting in the password when it requests it.

 

[Lifeseeker]

Thank you, it worked!

Yeah it remembers the password.

Sorry, I forgot you said 2007 at first.

To link you go to the EXTERNAL DATA tab on the Ribbon. Then you select ACCESS from the IMPORT group. When the dialog comes up you choose LINK instead of IMPORT. Then browse to the file you want and click ok. It will ask you for the password and then you select the tables you want. I just ran through it so I found there is no checkbox for this one - it isn't necessary for Access, it will remember the password once you've linked after putting in the password when it requests it.

 

[Bursal]

Hope it's OK to jump on an old thread.

Bob I have an Access 2010 split database. I want to do the same as Lifeseeker but I can't get your method to work. The backend is password protected, I deleted the table links in the frontend and relinked (not import) them. I had to add the password but the tables are still accessible. I don't have to add a password except to access the backend on the server.

I am not looking for hard and fast security just something to deter the ones want muck around with my tables.

Thanks Di