auot update

S

Souris

I would like to have my app auto update when update is available.
I can check the timestamp of muy mdb or version number on the server to copy
server version to local, but how do I let user continue running the app?
Must user close the app and re run it?

Any infomation is great appreciated,
 
A

Alex White MCDBA MCSE

the two methods I use is this either use a login script (if you have a
server) to copy down a new version on login or use a batch file to check for
a new version copy it if the version is out of date and then run it, you
cannot update the database whilst it is running, I copy the database to
c:\documents and settings\all users\desktop and this gives everyone the
database on their desktop.

Hope it helps.
 
S

Souris

Thanks for the information,

I use Access as front end application and SQL server as backedn.
Do you mean that I need have a login scripts from SQL server?
The script checks the version while user login. User will have the new
version when user login.


The second one is to copy new version to local drive, but user must close
and re run it.

Am I right?

Thanks again,
 
A

Alex White MCDBA MCSE

No NT user type logins.

you could have a batch file that does the following,

xcopy \\yourserver\data\myFE.mdb c:\"documents and settings"\"all
users"\desktop\myFE.mdb /c/r
msaccess.exe c:\"documents and settings"\"all users"\desktop\myFE.mdb

and put the batch file on the desktop.
 
Top