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

Access to Oracle 8i Commit

P: n/a
Hi all,
I am running some sql from Access 2000 to an existing Oracle 8i database
using the "INSERT INTO 'connection string for Oracle' etc etc. then the
docmd.runSQL which works fine. However I then have to open the Oracle SQL
Plus program and type 'commit' to finally commit the changes. I would like
to automate this last step from within Access. ie commit the Oracle changes
from within Access VB. Can this be achieved? If so can anyone be kind enough
to give me a quick syntax example.

TIA
Mark Day.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This should get you going in the right direction. the example is vb.net and
is very close to what you would do in old VBA

http://www.devcity.net/net/article.a...as=msaccess_sp

Part #2 ( the link is at the bottom of the page ) is also good reading

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Mark Day" <ma******@solortec.co.uk> wrote in message
news:bs**********@hercules.btinternet.com...
Hi all,
I am running some sql from Access 2000 to an existing Oracle 8i database
using the "INSERT INTO 'connection string for Oracle' etc etc. then the
docmd.runSQL which works fine. However I then have to open the Oracle SQL
Plus program and type 'commit' to finally commit the changes. I would like
to automate this last step from within Access. ie commit the Oracle changes from within Access VB. Can this be achieved? If so can anyone be kind enough to give me a quick syntax example.

TIA
Mark Day.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.