locking access to Tables

[harshad78]

I am pretty novice to MS-Access and especially the security features.

I have made an application which has many tables in it. One of the tables stores username and password in it.

Now I have made this nice interface using forms which would allow the user to enter some information in a table.
But before a user can do that, he is required to enter a username and password, which is again on a form with text boxes on it.

These enteries are matched with the table which has username and password in it. And if they are right it takes the user to a form which is nothing but the interface to enter information in the table.

I have made a switch board to navigate through this forms. But when the whole application starts, it also shows the table menu (which is minimized).

A knowledgeable user can directly go and open the table which has username and password and that's it......
The whole uname and pwd purpose is defeated.

NOW FINALLY THE QUESTION

Can someone please advise me, how can I make sure that the whole application runs as it is, but when someone tries to look into the table it should be password protected.

Thanks for your advise in advance.


Harshad

 

[Robert Dunstan]

You can do a couple things to start with:

1. In the startup options (under Tools Menu) untick 'Display Database Window'. To bypass startup options, hold down the Shift key when opening the db

2. You can hide the tables in the database window by right clicking on the table name, select properties and ticking the 'Hidden' attribute.

For securing your tables i.e. creating read / write permissions you'll need to investigate further the in-built security within Access with regards to creating workgroups. Also do a search on this site for Security and workgroup files. I myself haven't used the User-level security in Access so I can't help much here. But if you do a search as I suggest then you should find what you are looking for.

HTH
Rob

 

[jeremie_ingram]

Please take to heart that it is STRONGLY recommended that you investigate the access group options THUROUGHLY. Enabling the security of access can have adverse reactions on a network, especially if there are other access MDBs residing in it.

 

[harshad78]

Thanks

Robert Dunstan and jeremie_ingram Thanks
for your replies.

I think the suggestions given by Robert will effectively solve my purpose.