And still work when running the VBA ?
And still work when running the VBA ?
I have an Access database. Some people wants to use the tables in there to connect to other platforms. Those can be unlock. But I want to lock the other queries, forms and table that is not use. However I still want VBA to work. Can that be done, please advise.
I'm sorry to repeat myself but it still depends.
For example if you lock anything you want to alter using an action query (append/update/delete), then it won't work
I suggest you don't lock anything.
Instead HIDE the navigation pane so end users have no direct access to tables/queries etc
This is the standard approach to all multi-user databases
Then add suitable code to buttons on forms to perform whatever you want to do
Can it unlock, do the altering and appending and then lock it ? I already hide the navigation pane
Yes they can just use shift enter or I forgot the short cut and can access. Could you still provide me the example just in case.
Keep a development copy which allows you full access.
Remove the ribbon as well as the nav pane and disable shift bypass from the distributed version if you are that worried about users 'tampering'
See this example database for ideas and related code which will allow extra security https://www.accessforums.net/showthread.php?t=69856