I am writing an app that processes fitness event results (running races, etc) and I have a 'raw' access database with a single table that collects data from my timer. I want to transfer that data periodically to another access database, or another table within the same access database, to make changes and still preserve the data in the original table. I need to do this in vb6 code. I am ok writing and reading the data. I just need some advice on the best way to get data from the original to the 'edit' table/db to make my changes.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!