Solved: Table opens as query??

[alimcpill]

Hi experts,

I've got a table and when I try to open it it takes an inordinately long time, access says at the bottom that it's running a query. Anyone seen this before? Or even better know how to solve it?? All the fields are simple types, no lookups or anything nasty like that.

[jmenche]

It is possible that you sorted your table at one point and hit save when you closed it. Your table will save this "query" and will execute it every time you open it up. If your table is large it will take a long time to open. A quick way around it is to make a new table (copy the one you have and choose the 'Structure Only' option) and append your data to it and then delete the old one.

I amn't one of the experts (just a heavy user) so maybe somebody has a different answer.

P.S. Most substantive changes to tables are either saved automatically (data entry) or you are prompted to save the table first before proceeding (design mode). Therefore, if you spend a lot of time surfing around your tables maybe doing QC work or data entry, NEVER save your changes when you close it unless you are 100% of what you are doing.

[alimcpill]

Hi jmenche, I thought it might be something like that, but I was fairly certain I hadn't saved a sorted view of a table. I did some tests and found that the problem arose after I ran a bit of VBA code which was updating the table quite heavily through ADO. However, a similar solution to yours did the trick (SELECT ... INTO then delete the original ) so thanks for your input!