Full Version: Executing and UPDATE query in an external database
UtterAccess Forums > Microsoft® Access > Access Forms
WongMeister
Does anybody know how to do this?
I have a form in a local database. The form has a command button. I want to be able to click the command button, and have it reach out to an external database ("dbExternal"), and run an UPDATE query ("qryUPDATEdata) that is already in the external database.
Can this be done? I know how to run a select query of an external db, and import those to my local database, but just don't know how to just run an UPDATE query on it's own.
Thanks in advance.
vtd
You can "automate" the external database...
Create a Database object "dbExt" using OpenDatabase Method then use dbExt.Execute to run the UPDATE query in the external database.
WongMeister
Thanks Vanh. The terms are new to me, but I'll do some researching.
Thanks again,
Rich
vtd
You're welcome... Glad to help...
ost back if you still need help after your research & attempt(s) to implement the code.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.