ADO Question

Here is what I am trying to do.
I have 2 databases the first is a current database and the second is a backup database. They are in microsoft access.

Now I have 1 table in each database called customers. There are currently 95 fields in this table.
I want to move selected files from the current database to the backup database.

Can I, by using a dataset and dataadapeter, fill the dataset for the current database then somehow take that dataset and use it to update/insert the data into the backup database with a different connection? I want to do this without referencing each field independantly. Is this possible and how would I do it?

As always any help or suggestions are greatly appreciated.

Thanks,
Tomson

Hi,

"Now I have 1 table in each database called customers. There are currently 95 fields in this table. "

95 Fields or 95 Records?

How big is the database?

95 fields. I know this is large and not my doing, but this is what I have to work with. The database is a little over 2 gig.

Thanks,
Tomson

Hi,

I've tried a few things on this but cannot achieve specifically what you ask. Let's hope some of the other guys have some input.

What you can do provided that the backup database is EXACTLY the same as the main one, is to open two dataadaptors and when you update the main database table you also update the backup. You will have to note the row of the data being altered so that you can refer to this in your second dataadapter. This will achieve your object of only accessing the changed fields - presumably a requirement to speed things up.

Hope this helps.