Database Repair Help

[Johnson]

I am sharing an Access database that I created in Access 2000 on a WNT 4.0
server that frequently needs to be repaired. The database is used by less
than 7 users simultaneously. Some of the users have Access 2003 and some
have Access 2000. The dialog box indicating that the database needs to be
repaired pops up when users try to open the database but you can still use
the database on computers that had it open prior to the dialog box popping
up. Any ideas on what I could do to permanently repair the database would be
greatly appreciated. Thanks in advance.

 

[John W. Vinson]

I am sharing an Access database that I created in Access 2000 on a WNT 4.0
server that frequently needs to be repaired. The database is used by less
than 7 users simultaneously. Some of the users have Access 2003 and some
have Access 2000. The dialog box indicating that the database needs to be
repaired pops up when users try to open the database but you can still use
the database on computers that had it open prior to the dialog box popping
up. Any ideas on what I could do to permanently repair the database would be
greatly appreciated. Thanks in advance.

Split the database into a frontend (containing the forms, reports, queries,
etc.) and a Backend (containing only the tables). Give *each user* their own
copy of the frontend, all linked to the same backend.

See http://www.granite.ab.ca/access/splitapp.htm for the whys and wherefores
of this very standard technique.

John W. Vinson [MVP]