Using a password on a Split Database

[Adzi]

Hello,

For the past few years I have been developing Access DB systems for my current employer, however IT have now implemented new rules and therefore I have to ammend the way I store the data.

Currently I have a 'back-end' containing all the data tables, and a 'front-end', which the user accesses and contains all the forms and queries etc. The 'front-end' has linked tables to the 'back-end'.

I need to password protect the back-end (even though it's in a private share with only those who need to access it). Using Access' in-built password system will obviously cause issues with the linked tables...

Any work around apart from the glaringly obvious welcome form lock-out?

 

[SOS]

You can password protect the backend and then delete all of the current linked tables from your frontend. Then LINK them again (using the FILE > GET EXTERNAL DATA > LINK and then when you go to select the tables to link, there is a checkbox at the bottom right of the dialog which says REMEMBER PASSWORD. Check it and then your users won't need to enter the password each time they use the frontend.