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

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
FL - 22 May 2007 22:52 GMT
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.

Signature
FL
> > How can I delete one record whichs shows #error on fields. I get stuck in
> > an
[quoted text clipped - 36 lines]
>
> http://www.pksolutions.com
Susie Johnson - 22 May 2007 23:11 GMT
it is no longer reccomended to use User-level-security
you need to move to SQL Server and Access Data Projects
> 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
[quoted text clipped - 44 lines]
> >
> > http://www.pksolutions.com
Joseph Meehan - 23 May 2007 02:14 GMT
> 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!!

Signature
Joseph Meehan
Dia 's Muire duit
IRS Intern - 30 May 2007 16:28 GMT
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
On May 22, 6:14 pm, "Joseph Meehan" <sligoNoSPAM...@hotmail.com>
wrote:
> > it is no longer reccomended to use User-level-security
>
[quoted text clipped - 11 lines]
>
> Dia 's Muire duit