[AccessD] VBA to ActiveX

I somehow missed your question in previous visits. Did you receive a
satisfactory answer? In short, I would say that ALL such calculation-type
code that can be moved to the server SHOULD be moved to the server.
Depending on the particulars, you might use a sproc or a UDF, but I am most
definitely in the camp that what the back end can do the back end SHOULD do.

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: August 22, 2005 5:43 PM
To: AccessD solving'
Subject: [AccessD] VBA to ActiveX

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 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com