[AccessD] Macro vs VBA

Scott Marcus marcus at tsstech.com
Thu Apr 20 09:55:26 CDT 2006


<<My question is is there any difference,
<< benefit, concern, or anything to think
<< about when choosing between launching
<< these 3 queries with a macro or VBA?

Sure, How about error handling when the database links are broken or
when the database is unavailable (network outage, maintenance, etc.)?
You will have better options with VBA.

Scott Marcus

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, April 20, 2006 10:15 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Macro vs VBA

Hello All,

Some one contacted me with an app that links to an mdb that links via
odbc 
to informix(I think)...anyway...I'm going to put a few queries together
that 
create a local copy of the data...delete the old...that kinda stuff.  No
big 
deal...this mdb will do nothing else than house a temp recordset.  the
mdb 
will be running 1 append and 2 delete queries...once a day via a
scheduler.  
My question is is there any difference, benefit, concern, or anything to

think about when choosing between launching these 3 queries with a macro
or 
VBA?

Thanks,

Mark

P.S...Its funny how the simple projects bring more questions...


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 





NOTICE:  This electronic mail transmission is for the use of the named individual or entity to which it is directed and may contain information that is privileged or confidential.  If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of any information contained herein is prohibited.  If you have received this electronic mail transmission in error, delete it from your system without copying or forwarding it, and notify the sender of the error by replying via email or calling TSS Technologies at (513) 772-7000, so that our address record can be corrected.  Any information included in this email is provided on an “as is” and “where as” basis, and TSS Technologies makes no representations or warranties of any kind with respect to the completeness or accuracy of the information contained in this email. 



More information about the AccessD mailing list