VB how to copy table - Answer to XyFix

Hey Xy- sorry, the thread was closed before I could get back to you. Doug is right, you have no control over the order of records in the database, unless you redefined the primary key to force the DBMS to take the order you want it to have. You do have the ability, however, to create a query in MS Access and then use it as your datasource instead of using a table. The Query (why they can't just call it a view like everyone else, I'll never know) will update whenever you update the tables, and , the query can also be updated, which will then update the tables themselves. Does that help?

Thanks for replying. But I solved it by dropping the index of the column in the table and then created a index . All of this i did with sql statements, like drop index ..... but i don't have to tell you as you know it better than me. But anyway thanks for replying. Can you help me with my other post of appending contents to a table?

If I closed that thread it was purely by accident