The actual connection string will vary depending on the version of Office, OS, and the driver you choose.
Use the example in the Admin guide for ODBC databases to get the format of the query, then go to connectionstrings.com, your final answer is probably one of the examples on the Access connection strings page:
I'm not sure, but you may have to additionally create an ODBC datasource pointing to the Access file too....
Hi Jeff thanks for this. I suspect it's a 32 bit Access, 64 bit SQL incompatibility that's the root cause of the issue.
I'll have a look at the wbesite you suggested.
Check the Windows Application log on the server that hosts the Enterprise PDM Database Service, that will probably have an error (actually more like 1 per minute) about why it's failing to connect to the datasource