Password on Back End - 2007

[noboffinme]

Hi

As 2007 Access doesn't have user level security, I've applied a simple password entry form for the User to access the Front end, the code looks at a table for the Username & checks the password matches the password entry.

Problem is when I apply password encryption to the Back End, the code can't access the table that matches the password.

How do you get around the need to add a password to the backend (to protect it) & also give normal access (with this password code )to the Front End users.

Thanks

 

[DCrake]

Open the back end exclusively and set a password to the database by using the Encrypt with password

Then open your front end and relink your tables. You will need to provide the password for the first time. Once the tables have been lined you are not asked again. You can then use your normal password access control on the front end.

 

[noboffinme]

Thanks David

I split the database & then applied a password to the BE, I went & opened the FE & went to 'External Data' & selected 'Access' & selected 'link to datasource by creating a linked table'.

The wizard then links all the tables & adds '1' to the table name - I then deleted the original tables & removed the '1' from the new linked tables & all works fine.

Isn't the splitting & adding a password to the BE supposed to be less complicated than that or have I missed something?

Thanks for your help!!

 

[DCrake]

You should have deleted the previious links first.

 

[noboffinme]

Thanks David

I was concerned I would lose the relationships, but of course, they are now in the Back End !! Cheers

 

[boblarson]

I was concerned I would lose the relationships, but of course, they are now in the Back End

Which is where relationships need to be defined - in the backend (just confirming that for anyone who stumbles upon this in the future).