By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Copy new db

P: n/a
How do i create an icon on a users desktop that when double-clicked
automatcially goes out and copies a .mdb file from the server and
replaces the users .mdb file on their local drive. I know there is
some sort of dos file i can create, but dont know the syntax, also
what do i put in the startup in the icon properties?
thankx,
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 28 Jun 2004 13:53:18 -0700, mi******@boh.com (Mitchell Thomas)
wrote:

The recommended way is to use a VBScript file. That's just a text file
with some VBScript code. This code would presumably use the
FileSystemObject to copy the file from there to here. The script is
invoked with wscript.exe.

Want to be really slick: the front-end application checks its version
against a system table in the back-end. If no match, it downloads the
latest version from the network location. Perhaps this utility can be
of help: http://www.trigeminal.com/lang/1033/...asp?ItemID=8#8

-Tom.

How do i create an icon on a users desktop that when double-clicked
automatcially goes out and copies a .mdb file from the server and
replaces the users .mdb file on their local drive. I know there is
some sort of dos file i can create, but dont know the syntax, also
what do i put in the startup in the icon properties?
thankx,


Nov 13 '05 #2

P: n/a
mi******@boh.com (Mitchell Thomas) wrote:
How do i create an icon on a users desktop that when double-clicked
automatcially goes out and copies a .mdb file from the server and
replaces the users .mdb file on their local drive. I know there is
some sort of dos file i can create, but dont know the syntax, also
what do i put in the startup in the icon properties?


I use a batch file and point the shortcut at it:

XCOPY "x:\MyPath\MyGUI.mdb" C:\MyLocalPath /I
START "MyGUI" /MAX "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\MyLocalPath\MyGUI.mdb" /wrkgrp "x:\MyPath\MyFile.mdw" /user guest
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.