General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Ha... I get it, thank you.
oDC = CREATEOBJECT('ADODB.Connection')
oDc.OPEN('provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Compaq\mex\mexdata.mdb;'+;
'Jet oledb:system database=\\Compaq\mex\sysmex.mdw;user id=Admin;password=TEO')
But 1 problem, how to deal with transaction? eg. If insert of the 2nd table fail, how can I rollback the 1st table insert?
Thank u.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only