Cannot delete record: in table or via query

J

jokobe

I'm trying to delete a record. The record has the ID 6174.
I have tried to delete with DELETE * FROM my_table where customer = 6174 or
I open the table, select the record and click delete - but nothing is
happening.
No error message....
The record seems to be "broken" and contains in a field instead of a proper
value (actually a link) just the value #error. The field values can't be
changed...

Any helpful hint?

Thanks in advance

jokobe
 
A

a a r o n . k e m p f

wow.

if you have corruption, you should move to SQL Server

File, New, Project (existing data) in Access 2003
 
J

jokobe

Thanks for your fast answer....I have used that way (new table etc. ) before
but hoped for a work around....

Anyhow, thanks fro your help...

jokobe
 
B

BruceM

Aaron has only one response to every situation. He should be ignored. In
the occasional situation when moving to SQL Server is appropriate he is not
able to offer practical suggestions about the details of doing so.
 
A

a a r o n . k e m p f

whatever, fag

SQL Server is the only database you should be using-- Namely because
JET CORRUPTS

if you care enough to build a database.. build one that is stable.
ADP allows you to build simple forms and reports-- but against a real
database backend.. it is a much better platform
 
A

a a r o n . k e m p f

whatever, fag

SQL Server is the only database you should be using-- Namely because
JET CORRUPTS

if you care enough to build a database.. build one that is stable.
ADP allows you to build simple forms and reports-- but against a real
database backend.. it is a much better platform
 
R

Rick Brandt

jokobe said:
I'm trying to delete a record. The record has the ID 6174.
I have tried to delete with DELETE * FROM my_table where customer =
6174 or I open the table, select the record and click delete - but
nothing is happening.
No error message....
The record seems to be "broken" and contains in a field instead of a
proper value (actually a link) just the value #error. The field
values can't be changed...

Any helpful hint?
Click to expand...

Have you tried compact and repair?
 
Top