Hi,
I've got a problem with a senior manager trying to open an excel report I created. Everyone else can use this report except for this manager who is using Excel 2003.
The spreadsheet errors when trying to connect to an Access database using ADO ("conn.Open connStr" from the code below). I'm referencing the ADO 2.6 Recordset library, and have tried different libraries but they don't help.

Has anyone else had any problems with ADO in Excel 2003, or can anyone see what I'm doing wrong? Any help would be appreciated, as I can't see why this won't work...

This is the VBA code:
Const dbloc = "\\scsrv-03\mr$\Stock On Order.MDB"
....
Dim conn As New ADODB.Connection
Dim connStr As String
connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & dbloc & "; User ID=admin; Password=;"
conn.Open connStr
....