Hi, I've got an Excel Workbook containing two different data connections using MS Query which taps into an Access database on a shared network drive. The queries are working fine. Both the workbook & Access database are on the same shared drive. I am the person who constructed the workbook and data connections. The people here in the office have different drive letters for accessing the shared drive as many of us have access to other shared drives as well.
I set up the MS Query data connections from my computer. The problem is if someone else goes in the workbook and needs to refresh the data, it won't recognize the request because the data connections only recognize my drive letter assigned to the drive. They can look at the tables, but that's it.
I don't know enough about SQL to know if the Connection String can be edited to allow for this? For the Access database - I had no part in how it was designed or set up, but all of us are able to access it and make changes as needed to records.
The connection string currently looks like the below. The "J" is my shared drive letter. I am not able to download the file due to sensitivity of the contents. Thanks so much.
DSN=MS Access Database;DBQ=J:\XXXX DATABASE\Final Database\XXX Database Application - FE.accdb;DefaultDir=J:\XXX DATABASE\Final Database;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
I set up the MS Query data connections from my computer. The problem is if someone else goes in the workbook and needs to refresh the data, it won't recognize the request because the data connections only recognize my drive letter assigned to the drive. They can look at the tables, but that's it.
I don't know enough about SQL to know if the Connection String can be edited to allow for this? For the Access database - I had no part in how it was designed or set up, but all of us are able to access it and make changes as needed to records.
The connection string currently looks like the below. The "J" is my shared drive letter. I am not able to download the file due to sensitivity of the contents. Thanks so much.
DSN=MS Access Database;DBQ=J:\XXXX DATABASE\Final Database\XXX Database Application - FE.accdb;DefaultDir=J:\XXX DATABASE\Final Database;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;