Recent content by msanewbie

Finally figured it out. I found the solution using microsoft's support page. I had to switch Unique Records from No to Yes. I read this somewhere else, but for whatever reason I missed it. Here is my final sql view. I actually reverted to my original delete query and it worked. Thanks for...

Now I go back to the "Could not delete from specified tables" Here are the two sql views 1) select query 'undoSO' SELECT SO.* FROM SO INNER JOIN SOupdate ON (SO.[Security ] = SOupdate.[Security ]) AND (SO.Cusip = SOupdate.Cusip) AND (SO.Account = SOupdate.Account) AND (SO.[Settle Date] =...

In my linked table which is now a query, when I uncheck the fields or remove them when I run the delete query I get the following message "Query must have at least one destination field."

Now I get the following error "Could not delete from specified tables" My new delete query with sql view DELETE * FROM undoSO; undoSO was my previous delete query

Unfortunately, that didn't work. Same error message. I am basically trying to delete the records from the SO table, which are present in SOupdate table. I am using this query as an undo function on a form. SOupdate was populated with data from a file and in the event the user accidently runs the...

I read a few threads regarding this but I am unable to find a solution. I have two tables which I am using a delete query to remove data from. The first table 'SO' is my master table and 'SOupdate' is the table where I have data I want to remove from 'SO'. My delete query is as follows (SQL...