Database Replication/Sync

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
tcocAsked:
Who is Participating?
 
CharitygConnect With a Mentor Commented:
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
 
CharitygCommented:
try

"\\server\Folder\Subfolder\Replica of Automation.mdb"
0
 
tcocAuthor Commented:
Charityg,

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

tcoc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.