>do you have any resources that will talk me through connecting to the Access database correctly
Certainly, plenty of consultants available, although this may not be a big enough engagement for them.
You can open a support case with Microsoft.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!