Cannot delete #error on one record.

[Guest]

How can I delete one record whichs shows #error on fields. I get stuck in an
invalid argument when I try to enter the field to delete it. I click on OK
for invalid argument and it keeps coming back several times.

 

[Arvin Meyer [MVP]]

How can I delete one record whichs shows #error on fields. I get stuck in
an
invalid argument when I try to enter the field to delete it. I click on
OK
for invalid argument and it keeps coming back several times.

First make a copy (or 2) of the entire database file. Now compact one of
them and try and delete the bad record. It may disappear during to
compaction process, or you may be able to delete it now. If that doesn't
work try a copy the table (or all the objects) to a new database. If never
had to go beyond that to fix a record, but my standard corruption advice is:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Guest]

Thanks for the advise. I'll try to make a copy. However, my DB is split and
secure. I'll try to copy the BE in another location and run the
compact/repair on the copy. However, I may have a difficult time to open the
copy because it opens using a shortcut key which includes the workgroup file,
etc.

I already tried to compact on the original and it didn't do anything.

 

[Susie Johnson]

it is no longer reccomended to use User-level-security

you need to move to SQL Server and Access Data Projects

 

[Joseph Meehan]

it is no longer reccomended to use User-level-security

you need to move to SQL Server and Access Data Projects

You are too transparent Aaron, Changing your name only works for those
readers who would not know who you are anyway.

FL,

Sorry about Aaron - you get all types in a public forum!!

 

[IRS Intern]

I'm not doing this to 'hide' from you kids

i'm doing this because Microsoft is censoring posts on a PUBLIC server
i'm doing this because Microsoft is censoring posts on a PUBLIC server
i'm doing this because Microsoft is censoring posts on a PUBLIC server
i'm doing this because Microsoft is censoring posts on a PUBLIC server
i'm doing this because Microsoft is censoring posts on a PUBLIC server
i'm doing this because Microsoft is censoring posts on a PUBLIC server