insert/append query in vba..

N

nycdon

I'm working on an a2000 mdb linked to sql server tables. I'm pretty new with
sql server, and trying to copy a Form's row and it's associated subform rows.

The main form row copy is good, but not sure how to go about the subform row
copies..typically i would do an insert/append...

can i even do an Insert/Append query in VBA when using sql server? or do i
need a stored proc?

thx!
 
T

Tom Ellison

Dear Don:

Unless you are using a pass-thru query, it all works through Jet, so you
don't do anything different. SQL Server is where the tables are stored, but
Jet is interfaced to it and functions just like for a Jet database.

Tom Ellison
 
Top