Lonnie Johnson
prodevmg at yahoo.com
Mon Aug 22 16:42:46 CDT 2005
I have lots of VBA code in an Access datatabase that runs each night to update various tables and values based on certain conditions. Some of it is complicated such as calculating distance based on longitude and latitude and it is why I use VBA. However, I would like to move this processing over to our SQL Server. Would it be easy to convert some of the functions to DTS ActiveX packages? Is this even the way to go? I am looking to increase the performance and figured I could do so by moving it to the SQL Server side. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Start your day with Yahoo! - make it your home page