Access 2002 Application Mulituser Problems - Please Help 
Author Message
 Access 2002 Application Mulituser Problems - Please Help

Background:
I've recently converted an Access 97 application linked to SQL Server
back end into Access 2002. The multiple users of this app all open the
same front end file which is located on the server. Prior to the
conversion each workstation had their own system.mdw file with only
one user (the person at the workstation) listed in this file. After
the converstion to 2002, I created one system.mdw file with all users
and copied it down to each workstation.

The Problem:
Different users of the app want to create and edit their own forms and
reports when they are using the front end but after the conversion to
2002 they are sometimes not able to do this and get error messages
about not having the db open exclusively. This message appears only
sometimes, and this was not apparently a problem in the previous
version of access (97). Short of copying the front end file to every
workstation is there anything else I can do to avoid this problem?

Thanks in advance for your help.

Anya



Wed, 02 Jun 2004 05:22:36 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. spped problems with MS Access 2002 as client, Word 2002 as server

2. Help with this select query please; Access 2002

3. Need help with this query please. Access 2002

4. Please Help!!! Access 2002 and VBA Password

5. Application written for Access 2000 with DAO won't run in Access 2002

6. Access 2002 Word 2002 Automation

7. Word 2002 Access 2002 Automation

8. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

9. problem with excel 2002 and outlook 2002

10. Incremental Numbers - Mulituser Application

11. Incremental Numbers - Mulituser Application

12. 2002 to 2000 compatibility--help please

 

 
Powered by phpBB® Forum Software