Re: backend corrupt


chrisw_14@xxxxxxxxxxx wrote:
> 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

We also have this issue sometimes, but using an Access97 backend with
about 10 Access2000 frontends. We have not found a solution. It will
also leave a username apparently logged in the Security.LDB file.

-Mike

.

Relevant Pages

  • backend corrupt
    ... I have an Access database. ... There are about 6 frontends connecting to ... The backend is an Access 2000 backend. ... and they get a "Database is corrupt" message although the others are ...
    (comp.databases.ms-access)
  • 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: How to copy current db
    ... You cannot safely copy an Access database while it is in use. ... It also means that the backup itself may be incompatible (e.g. if you copied a table of related records just as someone was deleting a record on the ONE side of the join which then doesn't appear when you copy the primary table.) ... Allen Browne - Microsoft MVP. ... I could close the backend, ...
    (microsoft.public.access.formscoding)
  • 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: Secure Backend
    ... I have a backend database and several frontends. ... sensitive data that only users of one of the frontends are authorized ...
    (microsoft.public.access.security)