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
access read only

ResolvedVersion 2003

Lu has attended:
Access Intermediate course
Excel VBA Intro Intermediate course

Access read only

Hi I have a couple of reports in Access that a few others need to be able to view. I've built a form as a swtich board to open these report. Is there a way I can hide everything else in the database when open as normal, and just show this report page? I have seen something similar before.

Also can Access be open as read only without typing in any password?

Many thanks in advance.

Lu

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.