Database Repair Help

  • Thread starter Thread starter Johnson
  • Start date Start date
J

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.
 
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.
Click to expand...

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]
 
Back
Top