Re: Join Split Database

"Katherine R" wrote in message:
news:A06EB68D-DD48-4CB3-B2BA-D6DB6656B539@xxxxxxxxxxxxxxxx

> 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?

All of the links I provided should be reviewed at this point Katherine since
there is without question some corruption in this table. Make some backups
of this database immediately and use the techniques in the links on those
backups just in case something blows up.

I would start here first:

Jetcomp utility available at:
http://support.microsoft.com/?id=273956

--
Jeff Conrad
Access Junkie
Bend, Oregon


.

Relevant Pages

  • Re: Form Load
    ... > Jeff I live in Bend as well. ... A fellow Access Junkie in my town and I did not know about this? ... We should start our own Central Oregon Access Users Group. ... Bend, Oregon ...
    (microsoft.public.access.forms)
  • Re: Log Off Users during MAINT window
    ... Thank you Jeff. ... becoming an Access junkie. ... >(Look for KickEmOff2K sample database.) ... >(Look for Detect and Logoff Idle Users) ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Protect passwod
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ...
    (microsoft.public.access.security)
  • Re: password
    ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Jeff Conrad's Access Junkie List: ...
    (microsoft.public.access.security)
  • Re: How can I override Memo field size default to make it larger??
    ... > the memo field that I made for this table/db is confused. ... > entered about 750 characters to both the memo fields, ... Change the datatype to Memo in Design View of the table. ... Access Junkie ...
    (microsoft.public.access.gettingstarted)
Loading