Problem with delete Action Query in MS Access 2000

[BobbyRidler]

Hi,

I have an Access 2000 database that I have split into Client/Server or Front-Ent/Back-End design. The front-end runs on a Win 2000 work station and is linked to the back-end which resides on a NT file Server.

My problem is I have a delete query based on a table that has say 400 odd records. The query goes something like this "DELETE [Table1].*, *
FROM [Table1];". When I run the query I get a Miscrosoft Access message that says "You are about to delete (0) records from the specified table.

Our true blue IT Support have installed the latest MDAC version, which is 2.7 I believe. I installed and ran MDAC component checker to confirm this.

Does anyone have a clue as to why I would get such a wierd message from Access?
It is annoying to say the least as I have to double check the table to make sure the records were deleted.


Thanks in advance

Anthony

 

[VicM]

Anthony:

I am assuming you are trying to delete all the records from the linked table and not the table itself.

The SQL should read: "DELETE [Table1].* FROM [Table1];". Don't know why you've added the ,* to the statement.

Give that a try.

Hope this helps,

Vic

 

[Mellors]

Is it deleting but not reporting the correct status or is it just not doing the delete?
I would change your query to a select query and just check the query itself is looking at the data you expect.

 

[BobbyRidler]

Your right Vic, the SQL statement should have read "DELETE [Table1].* FROM [Table1];". That was my typo when starting this thread.

What I was really trying to say was that according to Mellors, all the records are being deleted but the status is being reported incorrectly by Access.

I changed the query to a select query and the correct number of records were displayed. I only get the incorrect message when I run it as a delete query.


Anthony