SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Run Macro/Function in Access database      SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic View next topic Run Macro/Function in Access database Author Message zhongqin Joined: 22 May 2008 Posts: 2 Country: United States Run Macro/Function in Access database Hi, How can run Macro or function in an Access database? I have create database profile but don't know if there is a command to run Macro/function. Thu May 22, 2008 12:05 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7966 Database profiles/connections are used for running SQL commands. Theoretically in Access you can call user-defined function from a SQL query, something like SELECT my_function() FROM some_dummy_table Thu May 22, 2008 12:28 pm zhongqin Joined: 22 May 2008 Posts: 2 Country: United States It dosen't work since We have alot of DoCmd.query in the function Thu May 22, 2008 12:58 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7966 In that case use VBScript jobs with Access COM automation. Using database connections is not appropriate for this type of automation. See http://support.microsoft.com/kb/147816 for details Thu May 22, 2008 1:21 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.