Microsoft Access Split Databases: Backend Passwords

[@asab0777]

Hello. First, thank you very much for these helpful videos! In your videos, have you covered somewhere a way to make the users interact with the tables using only the forms and queries in the front-end, and restrict them from accessing the back-end tables altogether? Thanks. Edit: Nevermind, found it!

[@xiangchen6]

I got the same question! which video did you find that's relevant?

[@christicharlebois3155]

hey,really great tutorials.i managed to password protect my back end as per the instructions however upon testing and tinkering i noticed that if you create a new database and select the external data option then instead of selecting the back end you instead select the front end, and choosing the import tables option,all the linked tables are exposed,access doesn't require the password and imports all the linked tables including the relationships and for some reason even creates a link..as in an update in the new database will reflect in the linked back end regardless of weather its password protected...is there a way to fix this or this is just an access vulnerability?

[@Accessjitsu]

It think this is an Access vulnerability. It has some security, but...

[@Thermonator621]

you didn't mention that you lose record level locking when doing this. you need to control record locking a different way.