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
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access database | Microsoft access developer | Microsoft access |
| Microsoft access database design | Microsoft access database training |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
