insert/append query in vba..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Access 2010 append query to SQL is very slow 0
Access 2007 - append query only appending 0 rows??? 0
Exicute an append query in an after update event 0
Append query in Access to SQL Server 2
Append Query in VBA (?) 7
Linked value in append query gives symbol value 2
append query creating new records 2

Back
Top