SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Run Macro/Function in Access database

 
Reply to topic    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

Post Run Macro/Function in Access database Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
zhongqin



Joined: 22 May 2008
Posts: 2
Country: United States

Post Reply with quote
It dosen't work since We have alot of DoCmd.query in the function
Thu May 22, 2008 12:58 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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.