On creating a new record which is practical to use?  Using .AddNew
of the the recordset or use an INSERT statement to make a new record?  And when using
INSERT, UPDATE and DELETE, is it more applicable to use ADO Command rather than
ADO Recordset?

Thanks,

Enzo
YahooID: onestepcloser2insanity

my systems are all SQL Server back-end, so I use stored procedures for
inserting, with each field a parameter of the procedure. The stored proc
then returns the new record it just inserted and I capture that in a
recordset object.

I also use stored procedures for updates and deletes and for some selects
(but I also use a lot of dynamic SQL from the VBA code for select).

if you are not using SQL Server this probably won't help much ;)

David

-----Original Message-----
From: enZo :-) [mailto:enzaux@g...]
Sent: Friday, September 20, 2002 12:29 AM
To: Access
Subject: [access] Which is better to use .AddNew or INSERT



	On creating a new record which is practical to use?  Using .AddNew
of the the recordset or use an INSERT statement to make a new record?  And
when using
INSERT, UPDATE and DELETE, is it more applicable to use ADO Command rather
than
ADO Recordset?

Thanks,

Enzo
YahooID: onestepcloser2insanity