<div>
What he said. (Which is to say, Sharmon deserves the points, not me.)<br />
<br />
But also, generally you don't save a database. The database provider writes any changes you make automatically. Once you change the database, for all intents and purposes, it is changed. There is no original that you can revert to later after saving to a different file.<br />
<br />
So with databases, copy then change, or extract then transform and import. Never change then save.
</div>


What he said. (Which is to say, Sharmon deserves the points, not me.)

But also, generally you don't save a database. The database provider writes any changes you make automatically. Once you change the database, for all intents and purposes, it is changed. There is no original that you can revert to later after saving to a different file.

So with databases, copy then change, or extract then transform and import. Never change then save.

<div>
chaos,<br />
<br />
You can use a disconnected recordset.<br />
<br />
1. Connect to source<br />
&nbsp; &nbsp;rs.ActiveConnection.Open &quot;DSN1&quot;<br />
2. Get a Recordset<br />
3. Disconnect<br />
&nbsp; &nbsp;rs.ActiveConnection.Close<br />
4. Update the Records<br />
5. Connect to a different source<br />
&nbsp; &nbsp;rs.ActiveConnection.Open &quot;DSN2&quot;<br />
6. Update<br />
&nbsp; &nbsp;rs.UpdateBatch<br />
<br />
I don't know whether this would work. It does sound reasonable, though.<br />
<br />
gbaren<br />

</div>


chaos,

You can use a disconnected recordset.

1. Connect to source
   rs.ActiveConnection.Open "DSN1"
2. Get a Recordset
3. Disconnect
   rs.ActiveConnection.Close
4. Update the Records
5. Connect to a different source
   rs.ActiveConnection.Open "DSN2"
6. Update
   rs.UpdateBatch

I don't know whether this would work. It does sound reasonable, though.

gbaren


<div>
This was the conclusion I was trying to avoid, but it seems like the only/best answer.<br />
Thanks.<br />

</div>


This was the conclusion I was trying to avoid, but it seems like the only/best answer.
Thanks.


<div>
<div class="content wysiwyg-content">
I want to connect to a database with the ADO data control, remove or edit a bunch of records and then save it to a different place. Is this possible? I haven't found anything in the help file or in the books I've been reading.
</div>
</div>


I want to connect to a database with the ADO data control, remove or edit a bunch of records and then save it to a different place. Is this possible? I haven't found anything in the help file or in the books I've been reading.

how can I copy an ADO database to a new database?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.