98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Switchboard -
Switchboard -
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Splittng a databaseSplit your database into two (at least). |