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.
On Oct 15, 1:41 pm, "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.
There are many ways to do what you ask. Perhaps, we could suggest the
best one if you told us a little more about why you want to copy the
record, and the circumstances in which it will be done.
Regardless, I am the world's second greatest ADO fan. But I can't
think of any case where I would use ADO to accomplish this task with
an Access/JET|ACE db. DAO is excellent at what it's excellent at. And,
in the opinion of this ADO lover, it's likely to be excellent at the
task you describe.
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 ***
On Mon, 15 Oct 2007 10:41:57 -0700, "Alex Chun"
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.
>