By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,076 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.

Select query deleting records!

P: 12
I had an Access 2007 database with 75,000+ records and 60 fields in a table created from data imported from Excel spreadsheets. When a select query was run which counted the totals for each entry in the Manufacturer field, an error message - "Record is deleted" and the option to click on OK or HELP - was received. Of course clicking OK was really the only option and when this was done records, not a single record but several, were gone from the table. The query was run several times with the same result.

When the record count reached 2000, the database was rebuilt - tables and queries. Since then the query runs without error, but I would like to know if anyone has experienced this same problem and what could be the cause.

Also, when trying to change the field type from text, after receiving the standard message about loosing data, Access 2007 shuts down and has to be restarted.
I have SP2 installed. Is there a possible problem with the installation? The workstation was upgraded two months ago.

Carol McSween-Brooks
May 5 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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