Password protection in Access

Resolved · Low Priority · Version Standard

Kate has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Kate [1 post] (2008 Mar 5 Wed, 09:44) Reply

Is it possible to password protect a specific table (i.e. that contains personal information) in an otherwise freely accessible database? If so, how?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Password protection in Access

by - trainer Pete platinum contributer [816 posts] (2008 Mar 13 Thu, 13:00) Reply

Hi Kate, Thank you for the post, sorry been off for a while. In answer to your question, you should follow the Access Database Security Wizard instructions, only applying the restrictions to the table in question, I have researched quite extensively and cannot find a way to only restrict a single table, so sorry on that one; hope that helps; best regards Pete.

· Access VBA Handling Errors and Debugging Code
· Microsoft Access Courses
· The Benefits of Certified Microsoft Training in Access
· Get More Out of MS Access Courses
· Want to Become the Office Hero? MS Project Training Could be the Answer

Please browse our web site to find out more about
microsoft/access/training/courses and other Microsoft training courses.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Rate this page: