switchboard

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Switchboard -

Switchboard -

resolvedResolved · Urgent Priority · Version 2003

Lisa has attended:
Excel VBA Intro Intermediate course

Switchboard -

Hi,

When on a course the tutor told me that you could have 2 databases which are linked together - one for the forms which you create but it reads from the data stored in another location. Is this correct? How do I do this if i have already created my database with all of my forms and data in it?

ALSO

I was told that you could create a different type of .mdb so as make this a view only database so as people can just view and search but not add - they did tell me how to do it but I have forgotten now.

RE: switchboard -

Hi Lisa

Thank you for your question

As to the first part of your question, the answer is yes you can; you have to split the database.

Simply go to Tools-database utilities-database splitter
and folow the wizard. Access will create two versions of the database, a front end with just the forms, queries, reports and macros, and a backend with just the tables. You can then make multiple copies of the front end for different users

As to your second question, the properties you are refering to are set against individual forms. Open the form in question and open its properties sheet, and set Allow Edits to False

Hope this is useful

Regards

Stephen


 

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


Server loaded in 0.08 secs.