By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

How to copy a record in VB/ADO

P: n/a
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.
Oct 15 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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 ***
Oct 15 '07 #2

P: n/a
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.
Oct 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.