Solved

Database Replication/Sync

Posted on 2001-06-20
3
261 Views
Last Modified: 2009-07-29
I'm trying to code a database sync, and I need to refer to the network drive where the replica resides.  The problem is that I keep getting an error saying that the path is invalid:

Private Sub cmdSynchronizeBOS_Click()

Dim dbsAutomation As Database

    Set dbsAutomation = CurrentDb
    ' Synchronize the local database with the replica on
    ' the network

    dbsAutomation.Synchronize "ServerName/Folder/Subfolder/Replica of Automation.mdb", _
        dbRepImpExpChanges

    dbsAutomation.Close

It works if I map the drive and do something like this:

dbsAutomation.Synchronize "g:/Folder/Subfolder/Replica of Automation.mdb", _
        dbRepImpExpChanges

The problem with doing that is that the g:/ drive is different user to user.

Any suggestions?

Thanks,

tcoc
0
Comment
Question by:tcoc
  • 2
3 Comments
 
LVL 2

Expert Comment

by:Charityg
ID: 6211555
try

"\\server\Folder\Subfolder\Replica of Automation.mdb"
0
 
LVL 2

Accepted Solution

by:
Charityg earned 50 total points
ID: 6211582
I guess I should have explained my solution a little. Using a double backslash is the standard convention for refering to the server directly. I think it has something to do with going to the root and finding the path from there, but I'm not sure. I just know it works, because I use it all of the time.
0
 

Author Comment

by:tcoc
ID: 6211621
Charityg,

Thanks it works great.  It's these little things that drive you crazy.

tcoc
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
query error in former passthrough query 2 31
SSMA Access BE Linked Table Migration Linking Issue 2 40
Parameter Query 33 50
MS Access Error Handling 6 28
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question