Re: Join Split Database

Wow - that was a quick response. Thanks so much. Sorry if this is a stupid
question - and I'm not even sure how to ask it - but is it the front end or
back end that I'm attempting to fix? I know the tables are in the back end
but isn't it the front end that I compact & repair? If all goes well and I'm
able to recover the corrputed db/table, should I have the users replace their
copies of the front end or is it sufficient that the table is repaired in the
back end?

"Jeff Conrad" wrote:

> "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: SQL Server Anxiety
    ... Based upon all of your collective feedback, I will ask those cost questions ... is to say that they already do backups. ... may need is a compact and repair -- but a compact and repair will not ...
    (comp.databases.ms-access)
  • Re: SQL Server Anxiety
    ... device/folder in which the Jet DB is located, ... may need is a compact and repair -- but a compact and repair will not ... Still need to do conventional backups and ...
    (comp.databases.ms-access)
  • Re: "There isnt enough memory to perform this operation"
    ... Our method of dealing with the problem so far is saving a lot and Compact & ... leaving Design mode. ... Run Compact & Repair on one of the copies. ... large app -- about 72 MB of program with tables linked to another Access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: #Name? error
    ... Have you done a compact and repair, or a decompile followed by compact and ... What happens if you create another database as a test, keep it simple, use ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
    (microsoft.public.access.forms)
  • Re: Form Dirty not firing
    ... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
    (microsoft.public.access.formscoding)
Loading