By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Access deleting updated records from update table

P: 1
Recently, I have a table that I use to update a master table. When I run the same Update query that's been successful in the past, most all of the data in the fields in the update fields has been deleted from the update table and nothing is updated in the updated table. Why would this problem start occuring and is there a remedy? thanks!
May 5 '06 #1
Share this Question
Share on Google+
2 Replies


P: 36
Can you post your query?

I'm not quite sure how an update query could delete a record, at worst it would set the fields to a null value/empty string.
May 6 '06 #2

P: 2
Access Version? If you have 2003, you should download all service packs.
Recently, I have a table that I use to update a master table. When I run the same Update query that's been successful in the past, most all of the data in the fields in the update fields has been deleted from the update table and nothing is updated in the updated table. Why would this problem start occuring and is there a remedy? thanks!
Sep 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.