access training - 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

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