View Full Version : Connecting to a remote BE-database


andrey_anikin
07-29-2008, 06:05 AM
Gentlemen,

I have an issue trying to connect to a remote backend-db that is residing on another PC in the LAN (192.168.x.x). What I do in order to reach the db is the following (wrk_spc is a workspace, and cust_db is a database):

Set wrk_spc = CreateWorkspace("my_space", "admin", "")
Set cust_db = wrk_spc.OpenDatabase("\\192.168.x.x\_shared_folder_name_\db_name_be.mdb", True)It works ok in my home LAN (where I use a computer name instead of an IP-address), but in the office LAN it says I give a wrong path. Anything I'm overlooking?

rainman89
07-29-2008, 06:07 AM
Im assuming you have tried the computers name instead of IP??

andrey_anikin
07-29-2008, 06:08 AM
I surely have, but it didn't work out either. Can it be a firewall-related issue, or am I doing something wrong on the Access side?

rainman89
07-29-2008, 06:14 AM
you can navigate to the folder from the computer you are trying to connect from correct?

andrey_anikin
07-30-2008, 01:08 AM
you can navigate to the folder from the computer you are trying to connect from correct?

It's not that simple - I can't see shared folders in the LAN by means of "View workgroup computers" (I guess it's the way the network is arranged). But I can ping that machine all right, so it should be accessible.