Transfer control to another database

[AlanS]

I remember seeing some code that would check the version of an access database and compare it to a revision number. If it was outdated, the code would transfer control to the patch database, shut down the calling database, and copy the current version of the database to the location of the calling user. I thought it was published in the Developer's Handbook or maybe Access Advisor, but I can't find it now that I need it

Can someone help me out, please.

 

[Joan Wild]

Perhaps you're thinking of this..
http://www.databasejournal.com/features/msaccess/article.php/3286111

--
Joan Wild
Microsoft Access MVP

I remember seeing some code that would check the version of an access

database and compare it to a revision number. If it was outdated, the code
would transfer control to the patch database, shut down the calling
database, and copy the current version of the database to the location of
the calling user. I thought it was published in the Developer's Handbook or
maybe Access Advisor, but I can't find it now that I need it.

 

[Van T. Dinh]

See if Tony Toews' AutoFE is the one you want:

http://www.granite.ab.ca/access/autoFE.htm

--
HTH
Van T. Dinh
MVP (Access)

I remember seeing some code that would check the version of an access

database and compare it to a revision number. If it was outdated, the code
would transfer control to the patch database, shut down the calling
database, and copy the current version of the database to the location of
the calling user. I thought it was published in the Developer's Handbook or
maybe Access Advisor, but I can't find it now that I need it.

 

[AlanS]

Joan, Thank you

That wasn't the example I remembered (I was thinking of something of the c.2001 vintage) but this one will do the job nicely. Just proves that there's always more than one way to get a task accomplished. And it added a few nice enhancements to the code I remember

Thanks again, I really appreciate you responding so quickly

AlanS