Hi,

Im attempting to connect to an Access data base on a server (running server 2003), from VBscripts run on the work stations.

It is my ultimate goal for the scripts to write to the database on the server, where the database is hidden and inaccesable by a non-admin user.

I have set up the ODBC souce on the server as a System DSN pointing to my database, and can access it fine on the server.

However when I run the scrips on other workstations they cannnot find the DNS.

Do I need to set up a connection from each workstation? and if so is there a way to advoid this?

The very small portion of code i'm using so far is :

Dim Connection
dim str

str = "UMdb"
Set Connection = CreateObject("ADODB.Connection")
Connection.Open str