VBA Code Only Works in Some Excel Versions

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:

Please Login or Register  to view this content.

Not assuming the obvious...Is the senior manager mapped to/have proper access rights to the shared server where the Access db resides?

Just a thought,
theDude