Matthew Snook
NW Salmon Database
- Local time
- Today, 06:33
- Joined
- Apr 19, 2001
- Messages
- 133
Situation:
Database is split, front-end and back-end. A back-end server sits in La Grande Oregon and is available on the net. Every other machine has an identical front end and a unique replica. These reside in identically named directories on each machine. The machines are in several cities in several states, and are supposed to synchronize via the internet. Which they do. Mostly.
Now that people are updating their machines I'm running into trouble. Those folks in far flung locations can use any OS they choose. I have some with W98, W2K, WXP. All of them work. However, some of the machines are not in other towns but are right here on my own LAN. If these machines are running windows 98 there is no problem, my code works just as well as if they were far away. But some of the newer machines are now running windows 2000 at the suggestion of the computer services folks.
If:
1) the machine is on my LAN;
2) the machine is running W2K;
On these particular machines, I get "Invalid HTTP Address" as an error message when they push the button which runs this code:
'start code
Dim rep As JRO.Replica
Set rep = New JRO.Replica
rep.ActiveConnection = "Data Source=C:\Datadirectory\Database.mdb; Password=psswrd; User ID=user; Jet OLEDB:System database=C:\Datadirectory\Securityfile.mdw"
rep.Synchronize "server.univ.edu/ServerDatabase.mdb", jrSyncTypeImpExp, _
jrSyncModeInternet
Set rep = Nothing
'end code
Notice that the code assumes the internet connection. No reference is made to any LAN or other connections. In other words, if the connection is _only_ available through the net, the machine responds suitably. But for those in my vicinity (on my LAN), W2K machines can no longer see the server on the web. Any ideas?
Thanks,
Matt
Database is split, front-end and back-end. A back-end server sits in La Grande Oregon and is available on the net. Every other machine has an identical front end and a unique replica. These reside in identically named directories on each machine. The machines are in several cities in several states, and are supposed to synchronize via the internet. Which they do. Mostly.
Now that people are updating their machines I'm running into trouble. Those folks in far flung locations can use any OS they choose. I have some with W98, W2K, WXP. All of them work. However, some of the machines are not in other towns but are right here on my own LAN. If these machines are running windows 98 there is no problem, my code works just as well as if they were far away. But some of the newer machines are now running windows 2000 at the suggestion of the computer services folks.
If:
1) the machine is on my LAN;
2) the machine is running W2K;
On these particular machines, I get "Invalid HTTP Address" as an error message when they push the button which runs this code:
'start code
Dim rep As JRO.Replica
Set rep = New JRO.Replica
rep.ActiveConnection = "Data Source=C:\Datadirectory\Database.mdb; Password=psswrd; User ID=user; Jet OLEDB:System database=C:\Datadirectory\Securityfile.mdw"
rep.Synchronize "server.univ.edu/ServerDatabase.mdb", jrSyncTypeImpExp, _
jrSyncModeInternet
Set rep = Nothing
'end code
Notice that the code assumes the internet connection. No reference is made to any LAN or other connections. In other words, if the connection is _only_ available through the net, the machine responds suitably. But for those in my vicinity (on my LAN), W2K machines can no longer see the server on the web. Any ideas?
Thanks,
Matt
Last edited:
