via VPN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Natalie Caplan - 11 Jul 2005 22:09 GMT

I have created a database that is replicated. The master is, of course, on
the network, then I have several global replicas for each region, from those
regional replicas I have created local replicas to Tablet PCs.
The problem, I have created a button so that users can "SyncUp" whenever
they are connected to a network; not within the company but via VPN. However,
the name for connecting to the server remotely is of a different name (i.e.
\\servername\volumenum vs. \\servernameremote\volumenum) and therefore Sync
thinks it's the wrong database. I've tried creating the replicas using a
mapped drive and then mapping the drive from the Tablet PC, but that failed
as well.
This is all done with VBA and I have tried to make it work manually. It
simply doesn't like the UNC name to be different.
Know any tricks to fake it out?
Thanks, Natalie

Reply to this Message

David W. Fenton - 11 Jul 2005 22:43 GMT

"=?Utf-8?B?TmF0YWxpZSBDYXBsYW4=?="
<NatalieCaplan@discussions.microsoft.com> wrote in
news:E2FCC32B-C8F4-4099-B813-A567AA71F083@microsoft.com:

> I have created a database that is replicated. The master is, of
> course, on the network, then I have several global replicas for
[quoted text clipped - 9 lines]
> This is all done with VBA and I have tried to make it work
> manually. It simply doesn't like the UNC name to be different.

How is it that the UNC name is different? I don't really understand
how that could be the case.

Is it possible to do it by IP address?

If so, you could perhaps use your HOSTS file to map the IP address
to the server name you need.

But I still don't understand why you don't have the correct name to
synch with.

Signature

David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Reply to this Message

Natalie Caplan - 12 Jul 2005 14:34 GMT

Thank you David for your quick response. It's the same server, only when
attaching to the server through VPN, you have to have a virtual name, hence
\\servernameremote\. I don't question this as I'm not the network engineer;
that's just what the engineer's tell me they need to do.

How do I get the replica to use IP to connect to the master and not UNC?
Thanks, Natalie

> "=?Utf-8?B?TmF0YWxpZSBDYXBsYW4=?="
> <NatalieCaplan@discussions.microsoft.com> wrote in
[quoted text clipped - 24 lines]
> But I still don't understand why you don't have the correct name to
> synch with.

Reply to this Message

Daniel - 12 Jul 2005 22:35 GMT

Natalie,

You could just check if the file exists on that server.

If Len(Dir("\\LocalServerName\MasterDB.mdb")) > 0 Then
'Do SyncUP for LocalServerName
Else
'Do SyncUp for RemoteServerName Command
End If

Daniel

> Thank you David for your quick response. It's the same server, only when
> attaching to the server through VPN, you have to have a virtual name,
[quoted text clipped - 34 lines]
>> But I still don't understand why you don't have the correct name to
>> synch with.

Reply to this Message

David W. Fenton - 12 Jul 2005 22:57 GMT

"=?Utf-8?B?TmF0YWxpZSBDYXBsYW4=?="
<NatalieCaplan@discussions.microsoft.com> wrote in
news:67DE3B14-D5CF-4492-AB1A-75AE0BE018F7@microsoft.com:

> Thank you David for your quick response. It's the same server,
> only when attaching to the server through VPN, you have to have a
[quoted text clipped - 4 lines]
> How do I get the replica to use IP to connect to the master and
> not UNC?

Well, you can replace the UNC name with the IP address:

\\servernameremote\YourReplica.mdb

\\123.456.789.012\YourReplica.mdb

Or, you can include an entry in the hosts file that maps the
server's remote IP address to the old server name:

123.456.789.012 originalservername

This is like using SUBST for drive letters in the old days of
DOS/Windows.

Signature

David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Reply to this Message