Delete query problem

Joined
Jul 27, 2010
Messages
1
Reaction score
0
Hello,
I have a DB I made in Microsoft SQL server, and I connected it to access, and now I'm making the interface for it.
I created a Delete query. I want to put a button in my form that runs this query BUT it's not working! I successfuly done this with selection queries. but when I get the window to chose the qry (when I add new button) the delete query isn't on the list. I clicked on "pass through" icon and chose the DB for this query, then I'm able to select it in the list and add to form, but it gives me errors like "incorrect syntex near * and near dbo_tblx " then I see that the SQL code is changed from this

Code:
DELETE FROM dbo_tblx
WHERE (((dbo_tblx.x)=[Enter number:]));

to this

Code:
DELETE *
FROM dbo_tblx
WHERE (((dbo_tblx.x)=[Enter number:]));
any advice on how to make that query run from my form??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top