Connecting to a remote BE-database

[andrey_anikin]

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]

Im assuming you have tried the computers name instead of IP??

 

[andrey_anikin]

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]

you can navigate to the folder from the computer you are trying to connect from correct?

 

[andrey_anikin]

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.