microsoft access training - Access Hide table in a splt database

The UK's most regular instructor-led training courses.
Training information: microsoft access training · Access course microsoft training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

1 post

ReplyFri 13 Apr 2007, 15:54Delegate Paul said...

Paul has attended:
Access Advanced course

Access Hide table in a splt database

I have split thedatabase and I want to stop other users from seeing my table in a soure database, thus giving complete security from other users.

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

428 posts

ReplyTue 17 Apr 2007, 11:07Trainer David said...

RE: Access Hide table in a split database

Hi Paul

I trust that you found your MS Access Advanced course useful.

Access does have a security feature within it that you might find useful. It will allow you to set up security and login's, so that you can control who sees what data.

To do within Microsoft Access go to Tools > security

Hope this helps
David

· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access Mistakes to Avoid
· Bring Access Up To Speed
· How much time could you save with Access?
· Access Database Optimization: First Normal Form

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips