i need to connect to a remote database on another server in a network. Because i am developing software at home i cant be sure if this works!
I use the following connection string



ConnectionString = "driver={Microsoft Access Driver (*.mdb)};" & _
      "server=andreavb.ipowermysql.com;uid=admin;pwd=;DBQ=C:program filesMicrosoft Visual StudioVB98nwind.mdb"


on my machine it works fine and i can see the database records! if i change the server variable in the previous string to match the server that has the database will it work?
I dont want to use DSN names

PLEASE HELP
      

Hi,

As far as I know, the Server attribute doesn't work on Jet, you will need to use the UNC path to the access database (ie. myservermypathmymdb.mdb), the mdb will need to reside in a directory that is shared on the remote machine.

Hope this helps,

Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)