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
