Forum home » Delegate support and help forum » Microsoft Access Training and help » access training - Access 2003 database
|
|
|
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. |
access training - Access 2003 database
Resolved · Low Priority · Version Standard
Reply Wed 7 Nov 2007, 13:49Delegate Simon said...
Simon has attended:
Access Advanced course
Access 2003 database
I have built my database , placed it on a local file server and now rolled it out everyone to use, however only the first person to open it can use the shortcut on their desktop. Once someone has it open it can only be opened elsewhere by opening Access on their PC and then opening the shortcut inside the Access enviroment. Please can you tell me why it won't open from shortcuts,Thanks.
For upcoming training course dates see: Pricing & availability
RE: Access 2003 database
Hi Simon
Thank you for your question.
When the other users try to open the database using the shortcut after the first person has accessed it using the shortcut, do any error messages come up?
thanks
Amanda
Reply Wed 14 Nov 2007, 08:16Delegate Simon said...
RE: Access 2003 database
Thanks for your response,
No , there are no error messages . the hourglass turns over a few times then nothing else happens. But opening the shortcut through access is still fine.
Thanks
Simon
RE: Access 2003 database
Simon,
Firstly please check to make sure you have set Access up to support multiple users. Each user should have there own login which will determine what they can and cannot access. I also suggest you investigate record locking so that your users are not changing the same data at the same time.
With the shortcut issue, I would advise just opening the database from within Access. It could be that the shortcut see the file as already being open. A shortcut does not support multiple users, where as the Access itself does.
One final point to note when using databases such as the one that you have created is, ensure you have a suitable backup procedure in place, as multi user Access databases are known to corrupt. I would maybe check to make sure you backup software can cope with open files.
Sorry if the doesn't 100% solve your problem, but I hope the advice helps.
David
|