Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
limited access database

Forum home » Delegate support and help forum » Microsoft Access Training and help » Limited access to database

Limited access to database

ResolvedVersion 2007

Jan has attended:
Access Intermediate course
Access Advanced course

Limited access to database

Create a full page form for users which fills complete page and does not allow access to tables, queries etc

RE: Limited access to database

Hello Jan,

If you go to Tools, Start-Up, you will see options including unchecking Display Database Window and also unchecking the menus (so that they cannot go via different routes to queries etc). Just make sure you have your own same copy or two which does have access to these first otherwise you might lock yourself out. This will mean they will only see the forms you allow commencing with the form you select to open with in the Start-up option and buttons to any others from that form. If the form doesn't open to fill the window they can maximise it, but I think there is a way to ensure it opens maximised. In any case in doing the above the database window will not be present in the background.

Regards, Mark

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.