backend corrupt


I have an Access database. There are about 6 frontends connecting to
the backend. The frontends are developed in 2000 but run on Access
2002. The backend is an Access 2000 backend. Once a week I get a
problem where one user tries to log in while other users are connected
and they get a "Database is corrupt" message although the others are
able to use the database ok. I have to tell everyone to disconnect and
I repair it before they can go back in. Every time this happens there
are one or 2 records that are corrupted after the repair. I've
developed other Access databases and never got this problem. Any ideas
of why it is corrupting?

Chris

.

Relevant Pages

  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
    (comp.databases.ms-access)
  • Re: backend corrupt
    ... > I have an Access database. ... There are about 6 frontends connecting to ... The frontends are developed in 2000 but run on Access ... The backend is an Access 2000 backend. ...
    (comp.databases.ms-access)
  • Migration to XP
    ... applications with a SQL Server 6.5 backend to Access 2002 ... and our W98 clients to WXP. ... installed and so you cannot print or design reports). ... >databases and other Access database versions we may have ...
    (microsoft.public.access.conversion)
  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... How can I even fix this dodgy design? ... database structure when we migrate ...
    (comp.databases.ms-access)
  • Re: Pound sign in Access generates an error
    ... The only way I know of to remove the corrupt record is to make a new ... There is a record in the database that contains the string ... > "#Error" for a memo field. ... > containing the "#Error" string is inserted in the Access database via a C# ...
    (microsoft.public.access.forms)