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.

--
FL

"FL" <(E-Mail Removed)> wrote in message
news:5A40B13B-538B-4044-A2AC-(E-Mail Removed)...
> 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...b;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...b;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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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


"Arvin Meyer [MVP]" wrote:

> "FL" <(E-Mail Removed)> wrote in message
> news:5A40B13B-538B-4044-A2AC-(E-Mail Removed)...
> > 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...b;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...b;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
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
>
>

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

you need to move to SQL Server and Access Data Projects



"FL" <(E-Mail Removed)> wrote in message
news:E7CED911-2423-484A-9547-(E-Mail Removed)...
> 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.
> --
> FL
>
>
> "Arvin Meyer [MVP]" wrote:
>
> > "FL" <(E-Mail Removed)> wrote in message
> > news:5A40B13B-538B-4044-A2AC-(E-Mail Removed)...
> > > 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...b;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...b;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
> > --
> > Arvin Meyer, MCP, MVP
> > http://www.datastrat.com
> > http://www.mvps.org/access
> > http://www.accessmvp.com
> >
> >
> >
> >

Susie Johnson wrote:
> 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!!

--
Joseph Meehan

Dia 's Muire duit

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:
> Susie Johnson wrote:
> > 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!!
>
> --
> Joseph Meehan
>
> Dia 's Muire duit