Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

Cannot delete #error on one record.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FL - 22 May 2007 22:25 GMT
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.

Signature

FL

Arvin Meyer [MVP] - 22 May 2007 22:33 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.