Restrict user access for tables and queries in MS access

vba ms-access ms-access-2013
goutam picture goutam · May 23, 2016 · Viewed 8.2k times · Source

I have an MS access database with 4 tables, 4 queries and 1 form.

Is there a way to restrict the users to see only the form when they open the access file. Something on the lines of a password protection to open the tables would also suffice.

Note: I am aware of the Hide Objects and Groups in MS access (https://support.office.com/en-us/article/Manage-database-objects-in-the-Navigation-Pane-04f0708d-c7c7-46bc-8c0a-670751f93d36) but I dont think there is a password protected feature to achieve this, any user who knows how to unhide will be able to view the tables and queries.

Answer

blckbird picture blckbird · May 23, 2016

MS Access provides a couple of start up options. Including to hide and disable many of the features.

Also, you can define a form to open on start up of the file like this:

Access Options > Current Database > Display Form, select the form you want to show up on starting the file.

When scrolling down a little more, you could e.g. disable "Display Navigation Pane", to not show the left hand pane with forms, tables, queries, etc.

BTW, when holding the shift key on starting a file, all start options are disabled.

Check out this video where all the details are explained.

Related questions

Combobox null in if statement

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this: Private Sub ProjectAddSetDateAutoBtn_…

Read More
ADODB doesn't exist in Access 2013 project, how do I add a reference to it

I am trying to rebuild an Access adp project in Access 2013 as and mdb. The tables are all linked tables in both version so that is not an issue. I have imported the forms from the old project so the …

Read More
On Click Error: "occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control"

Seems like this is has been asked a few times before. After working on a form for a few weeks, I suddenly get the error when I click on a button: "The expression On Click you entered as the event …

Read More