MS Database Distribution and upgrades

[MKH2001]

All,

A brief question before I make an fumbled attempt of my own at trying to resolve this.

I currently have a MS Access database sitting on a Citrix box.
Users connects via logging on through citrix without any interface with any desktop.
Instead the connection opens up the MS Access database direct in the application.

I have a backend and a front end.

What I was wondering is what method would be most practical in order to ensure the following:

I update the development front end, create a new .mde.
User tries to log in, some form of script/batch either internal or external to the end target database check the current mbe sitting on their local space on citrix and replaces it if not current.

Issue is I havent been able to execute a check and/or replace method within the ms access enviroment... say something similar to a batch:

xcopy /e /v /y /H "C:\WorkOrd\OtherApps\SLDB\*" H:\Users\<NETWORKUSERNAME>\SLDBDistributed\SLDBDistributedFE.mde

However if I try a batch on logon I have not figured a way of capturing the <NETWORKUSERNAME> variable for the target path.

Could someone suggest which direction I should be looking in order to implement something like this?

 

[Remou]

Have you considered using VBScript for this? The script can check if a new version exists and either copy or open accordingly.