I have a server that contains a database and a workbook.
The workbook code uses ADO to connect to the database, run
a query and return the results to the worksheet.

'Where cn is my ADODB.Connection
"cn.Open "Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\DatabasePath\DatabaseName.mdb;"

This works fine.

On another computer, I have a folder that is shared to
that folder on the server. I want to open the same
workbook from this shared folder and run the code. I'd
need to modify the statement to something like this:

'Where cn is my ADODB.Connection and V is the mapped drive
letter to DatabasePath.
"cn.Open "Driver={Microsoft Access Driver
(*.mdb)};Dbq=V:\DatabaseName.mdb;"

The problem is I'd like to have my code detect the path to
the database (depending from where I'm opening the
workbook) and set up the string accordingly.

Any suggestions?

tod

Use this instead... will work no matter what machine your on.

\\databaseserver\databasepath\databasename.mdb

Dennis

"Tod" wrote in message
...
I have a server that contains a database and a workbook.
The workbook code uses ADO to connect to the database, run
a query and return the results to the worksheet.

'Where cn is my ADODB.Connection
"cn.Open "Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\DatabasePath\DatabaseName.mdb;"

This works fine.

On another computer, I have a folder that is shared to
that folder on the server. I want to open the same
workbook from this shared folder and run the code. I'd
need to modify the statement to something like this:

'Where cn is my ADODB.Connection and V is the mapped drive
letter to DatabasePath.
"cn.Open "Driver={Microsoft Access Driver
(*.mdb)};Dbq=V:\DatabaseName.mdb;"

The problem is I'd like to have my code detect the path to
the database (depending from where I'm opening the
workbook) and set up the string accordingly.

Any suggestions?

tod