I am attempting to provide an error prone user the ability to do an on-line backup of important tables prior to them screwing up an update. How can I copy an entire table from one table name to another either within the same database or to an external database, all within Visual Basic 6.0?
I attempted to do it with a simple loop, using DAO 3.51, essentially reading and writing records. But when it runs on their NOvell network, it will get a 'record lock' error, and kill the backup. It works flawlessly on a standalone system, but not on their network, even with a delay built in between each read and write. I know that is the low tech way to do it, but haven't been able to figure out how to copy the entire table.
Any help will be greatly appreciated.
Steve