Re: [Talk] how to run an action query via VB

[Dwight Clevenger]

Scott, You should be able to run a Macro that calls the make table query. This clip of code works for me:   Sub DoAccessAutomation  Dim objApp As Object  Dim CurrentDb As String  CurrentDb = "C:\Documents and Settings\dcleveng\My Documents\SimPrcUpdate.mdb"  Set objApp = CreateObject("Access.Application")  With objApp   .opencurrentdatabase CurrentDb   .docmd.runmacro "mcMaketbl"   .Quit  End With Set objApp = Nothing End Sub Feel free to call if you have any questions     Thanks,   Dwight Clevenger Senior System Analyst Baptist Health System 615 Soledad San Antonio, TX. 78213 210-297-1563 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 10/12/2004 10:48:53 AM >>> Hello, I am able to run an Access DB query using VB object code but from what I have researched action queries can not be run in the same way.  Has anyone done this before?  The action query makes a table. thanks, Scott Zimmerman, LIS Analyst UMass Memorial, Worcester, MA Email:  [EMAIL PROTECTED] Office:  508-334-7237 Pager:  508-426-2178 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, transmission, re-transmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.  If you receive this in error, please contact the sender and delete the material from any computer. This email and any files transmitted with it may contain information that is PRIVILEGED AND CONFIDENTIAL. It is the property of the Baptist Health System and is intended only for the use of the intended recipient. If you have received this email in error, do not disseminate, distribute, forward, print or copy this email or any of its' attachments. Immediately destroy/purge the email and all attachments and notify the sender by reply of email. Any misuse/abuse may result in disciplinary action and/or legal liability. Unauthorized interception of this email is a violation of federal law.