How to copy a record in VB/ADO

[Alex Chun]

How can I copy a record into a new record, in VB using ADO? The table has
an autonumber ID field, and I need to change one other field (out of about
30) in the new record.

Thanks in advance.

[Rich P]

Greetings,

The best usage for ADO is for dealing with external data -- data that
does not reside in the Access mdb. It is possible, however, to use ADO
within the Access mdb project, but that would be a little more work than
using native DAO for manipulating data within the Access mdb.

The big thing with ADO is that it is like a translator system. You can
write Transact sql in ADO (sql for Microsoft Sql Server), or PL sql
(Oracle sql) or Jet sql (sql for Access mdb's) and read the results of
the data pull right into an Access mdb table.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Tom van Stiphout]

On Mon, 15 Oct 2007 10:41:57 -0700, "Alex Chun"
<ac***@nospam.u.washington.eduwrote:

You could use an Append query.
-Tom.

>How can I copy a record into a new record, in VB using ADO? The table has
an autonumber ID field, and I need to change one other field (out of about
30) in the new record.

Thanks in advance.