Re: Join Split Database

Thanks for responding, Jeff. I scrolled through the table and found a record
with #ERROR in the memo field. I deleted the record and did a
compact/repair. Now when I try to import the table I get a 'Record is
deleted' error (Error 3167). I scrolled through the table again and found a
different record with #DELETED in the memo field. I've deleted that record
and I'm reading from the links you directed me to to try and find a solution.
My understanding of access is limited so a lot of this may be over my head.
Am I on the right track so far?

"Jeff Conrad" wrote:

> "Katherine R" wrote in message:
> news:F67B3B27-6FC4-46A7-B651-8A0FA8071038@xxxxxxxxxxxxxxxx
>
> > I need to rejoin a split database. I've removed all the linked tables (4) and
> > I've imported 3 of the 4 tables from the back end database. Unable to import
> > the 4th. The message is "The Microsoft Jet dabase engine stopped the process
> > because you and another user are attempting to change the same data at the
> > same time." There are no other users while I'm doing this. I'm sure I've
> > done this before with no problems. Does anyone know what could be going
> > wrong this time?
> >
> > Thanks in advance for any help you can offer. This has had be stumped for
> > days.
>
> Hi Katherine,
>
> This could indicate some kind of corruption if you are sure no else is using
> the file and there is no LDB file present. The above message is one possible
> symptom of corruption:
>
> http://www.granite.ab.ca/access/corruption/symptoms.htm
>
> See if these links on corruption help.
>
> http://allenbrowne.com.au/ser-47.html
>
> http://www.granite.ab.ca/access/corruptmdbs.htm
>
> http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry
> (See Fix Corrupt Access Database v3.9 Document)
>
> http://www.e-tech.ca/001-AccessFAQ.asp
>
> http://www.everythingaccess.com/tutorials.asp?ID=0
>
> ACC2000: How to Recover Data from a Corrupted Table by Using the DAO Method
> http://support.microsoft.com/?id=815280
>
> ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
> http://support.microsoft.com/?id=306204
>
> ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
> http://support.microsoft.com/?id=209137
>
> ACC2000: How to Recover Data from a Damaged (Corrupted) Table
> http://support.microsoft.com/?id=247771
>
> ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database
> http://support.microsoft.com/?id=304561
>
> Jetcomp utility available at:
> http://support.microsoft.com/?id=273956
>
> Good luck,
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
>
>
.

Relevant Pages

  • Re: module error?
    ... Sounds like some kind of possible corruption. ... (See Fix Corrupt Access Database v3.9 Document) ... How to Recover Data from a Corrupted Table by Using the DAO Method ... How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database ...
    (microsoft.public.access.modulesdaovba)
  • Re: Join Split Database
    ... > I've imported 3 of the 4 tables from the back end database. ... This could indicate some kind of corruption if you are sure no else is using ... How to Recover Data from a Corrupted Table by Using the DAO Method ... How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database ...
    (microsoft.public.access.gettingstarted)
  • Re: ID is not an index in this table
    ... This does sound like some form of corruption. ... I would make several backup copies of your database ... How to Recover Data from a Corrupted Table by Using the DAO Method ... How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database ...
    (microsoft.public.access.formscoding)
  • Re: Error Message 3197
    ... > I am trying to open a shared database the is opened by users exclusively, ... I would seriously review the following information on corruption as ... How to Recover Data from a Corrupted Table by Using the DAO Method ... How to Troubleshoot Corruption in a Microsoft Access Database ...
    (microsoft.public.access.modulesdaovba)
  • Re: Attempt to fetch logical page
    ... You have a corruption in your database. ... Second, if you are on SQL Server 2000, check the specific recommendations for your error. ... This error occurs when Microsoft® SQL ServerT detects database corruption. ... execute DBCC CHECKDB to determine the extent of the damage. ...
    (microsoft.public.sqlserver.server)