Connecting to REMOTE Access DataBase

[jsparks]

I have a system DSN setup on an NT server on my LAN. It uses the Microsoft Access Driver, and points to an Access2000 .MDB file on the server.

I am writing a visual basic application that needs to use this datasource from whatever workstation the app is being run on.

All I can find are examples, tutorials, and articles about connecting to an .MDB file located on the same machine the app is running on, or to an ODBC source located on the same machine the app is running on. I simply can not find info about how to specify what server the ODBC source is located on.

Can someone please help me out with this? I'm new to VB6, my project depends on this ODBC connection, and it's all getting very frustrating. Any help would be appreciated. Thank you.

Jim

 

[edderic]

your can connected to a server like :

bedrijf = "\\PINTA\GENERAL\Timesheet\Database\TSHMedia.mdb"

Pinta is the server on a Network (the rest are Dirs on the server)
Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com