Forum home » Delegate support and help forum » Microsoft Access Training and help » Being able to use the data base
|
|
|
The UK's most regular 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. |
Being able to use the data base
Resolved · Low Priority · Version 2003
Reply Tue 27 Apr 2010, 16:51Delegate Jackie said...
Jackie has attended:
Access Introduction course
Access Intermediate course
Being able to use the data base
Having problems using the database when my colleague is up-dating and designing the database is this normal?
For upcoming training course dates see: Pricing & availability
RE: Being able to use the data base
Hi Jackie,
Thank you for your question and welcome to the forum.
If the database is on a shared drive, if your colleague is in Design View of a table changing data types or field sizes, you will only be able to open the table in design mode in read only.
You can however still run the queries, add data via the forms or print reports.
I hope this answers your question.
Regards
Simon
RE: Being able to use the data base
Hi Jackie,
Just to add a little extra to the last reply...
If your colleague has a form or table open in Design view you may not be able to open the database until they have finished their changes in Design view.
When you open a database you can open it in exclusive mode which means no-one else will be able to open it until they have finished.
I hope this helps.
Regards
Simon
Wed 5 May 2010: Automatically marked as resolved.
|