Cannot delete record: in table or via query

Interesting places

news.only-4-geeks.com Forum Index » Access


	Cannot delete record: in table or via query

Jump to:

jokobe

Posted: Tue Aug 19, 2008 9:46 am Post subject: Cannot delete record: in table or via query

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

Allen Browne

Posted: Tue Aug 19, 2008 10:42 am Post subject: Re: Cannot delete record: in table or via query

Quote:

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

jokobe

Posted: Tue Aug 19, 2008 1:34 pm Post subject: Re: Cannot delete record: in table or via query

Can't follow you....I don't have SQL-Server, only MSAccess....

jokobe
"a a r o n . k e m p f @ g m a i l . c o" wrote:

Quote:

wow.

if you have corruption, you should move to SQL Server

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

On Aug 19, 5:42 am, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
See:
Recovering from corruption: #Deleted in some rows
at:
LINK

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jokobe" <jok...@discussions.microsoft.com> wrote in message

news:264EA2E8-8384-45A2-BDF1-7276D44A88CE@microsoft.com...

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

jokobe

Posted: Tue Aug 19, 2008 1:35 pm Post subject: Re: Cannot delete record: in table or via query

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

"Allen Browne" wrote:

Quote:

See:
Recovering from corruption: #Deleted in some rows
at:
LINK

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - LINK
Reply to group, rather than allenbrowne at mvps dot org.

"jokobe" <jokobe@discussions.microsoft.com> wrote in message
news:264EA2E8-8384-45A2-BDF1-7276D44A88CE@microsoft.com...
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

BruceM

Posted: Tue Aug 19, 2008 1:48 pm Post subject: Re: Cannot delete record: in table or via query

Quote:

Can't follow you....I don't have SQL-Server, only MSAccess....

jokobe
"a a r o n . k e m p f @ g m a i l . c o" wrote:

wow.

if you have corruption, you should move to SQL Server

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

On Aug 19, 5:42 am, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
See:
Recovering from corruption: #Deleted in some rows
at:
LINK

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jokobe" <jok...@discussions.microsoft.com> wrote in message

news:264EA2E8-8384-45A2-BDF1-7276D44A88CE@microsoft.com...

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 r o n . k e m p f @ g

Posted: Tue Aug 19, 2008 2:30 pm Post subject: Re: Cannot delete record: in table or via query

wow.

if you have corruption, you should move to SQL Server

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

On Aug 19, 5:42 am, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:

Quote:

See:
Recovering from corruption: #Deleted in some rows
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jokobe" <jok...@discussions.microsoft.com> wrote in message

news:264EA2E8-8384-45A2-BDF1-7276D44A88CE@microsoft.com...

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

Bob Quintal

Posted: Tue Aug 19, 2008 9:45 pm Post subject: Re: Cannot delete record: in table or via query

jokobe,

please ignore aaron.

aaron is a troll, and posts irrelevant, insulting or erroneous
information
aaron should go away.

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com>
wrote in
news:d38dbc63-7f2b-4754-a23f-7b2fad3ad206@j1g2000prb.googlegroups.com
:

--
Bob Quintal
strThisMsg = replace(strThisMsg,"aa","mo")
PA is y I've altered my email address.
** Posted from LINK **

a a r o n . k e m p f @ g

Posted: Wed Aug 20, 2008 3:03 am Post subject: Re: Cannot delete record: in table or via query

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

On Aug 19, 8:48 am, "BruceM" <bam...@yawhodotcalm.not> wrote:

Quote:

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.

"jokobe" <jok...@discussions.microsoft.com> wrote in message

news:8B030DC5-6F68-4D52-8447-CBBE66048C3F@microsoft.com...

Can't follow you....I don't have SQL-Server, only MSAccess....

jokobe
"a a r o n . k e m p f @ g m a i l . c o" wrote:

wow.

if you have corruption, you should move to SQL Server

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

On Aug 19, 5:42 am, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
See:
Recovering from corruption: #Deleted in some rows
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jokobe" <jok...@discussions.microsoft.com> wrote in message

news:264EA2E8-8384-45A2-BDF1-7276D44A88CE@microsoft.com...

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- Hide quoted text -

- Show quoted text -

a a r o n . k e m p f @ g

Posted: Wed Aug 20, 2008 3:03 am Post subject: Re: Cannot delete record: in table or via query

Quote:

Rick Brandt

Posted: Sun Aug 24, 2008 10:13 am Post subject: Re: Cannot delete record: in table or via query

jokobe wrote:

Quote:

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?

Have you tried compact and repair?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Page 1 of 1 .:.



Awesome Website Templates ©

Ciekawe artykuÅ‚y srebro mobing gratka Kwiaty

Cannot delete record: in table or via query

Awesome Website Templates ©