[AccessD] Is it possible to update VBA code with VBA?

Hi Mark,

At one time I did use Tony's AutoUpdater, but at one customer it didn't work
and I couldn't figure out why.  So I made my own AutoUpdater and now use
that at each customer.  Interestingly, I've needed to modify it for each
customer due to each of their 'uniqueness' attibutes!  ;-)

I used to use the FE.mdb's LastModifiedDate as the decision parameter to see
if a file should be updated.  But occasionally the user's FE.mdb
LastModifiedDate would be updated automatically on the client PC, and then
they wouldn't get the updated files from the server.  So I came up with the
frmLatestUpdate and tblLatestUpdate method to have a more certain decision
parameter.

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Friday, January 14, 2011 7:31 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Is it possible to update VBA code with VBA?

Dan - that is very clever. Have you linked this into Tony Toew's AutoUpdater
or did you build your own MDE/ACCDE refresh-from-network utility ?

>
> This is what I do:
>
>
> Note - I use this primarily so that a client app will be automatically
> updated from the server when a user logs in.
>


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