ASP.NET, SQL Server, WPF, C#, VB.NET

add it into script to run sync? 
 
The script used to sync data requires fullname of file, including drive 
 
letter.  Some users map the network folder to differing drive letters.  I 
 
want to write a script to allow the user to browse to the location of the 
 
network data file and then drop the file name 
 
("P:\networkfoldername\appname\data\data.mdb") into the script below to sync 
 
to the local data file. 
 
intMsgBoxReply = Msgbox("Do you want to Syncronize your data file?", 
 
vbOKCancel) 
 
If intMsgBoxReply = 1 Then 
 
DoCmd.Beep 
 
DoCmd.Hourglass (True) 
 
varRet = SysCmd(acSysCmdSetStatus, "Syncronizing, please wait...") 
 
DBEngine.Workspaces(0).OpenDatabase("d:\data\data.mdb").Synchronize 
 
"P:\networkfoldername\appname\data\data.mdb", dbRepImpExpChanges 
 
varRet = SysCmd(acSysCmdClearStatus) 
 
DoCmd.Hourglass (False) 
 
DoCmd.Beep 
 
End If 
 
-- 
 
Thanks, 
 
Mike

Take a look at http://www.mvps.org/access/api/api0001.htm at "The Access 
 
Web" 
 
-- 
 
Doug Steele, Microsoft Access MVP 
 
http://I.Am/DougSteele 
 
(no private e-mails, please) 
 
"Mike Madison" <MikeMadison@discussions.microsoft.com> wrote in message 
 
news:71E0CD6E-4A48-470D-AEB0-E6439E09A300@microsoft.com...