Not sure if this is the best section to post this in, but I'm hoping someone here can help me out.
I have a split database that I have implemented, have about 3-4 people using it. One of the tables in this database is a linked table with excel. The problem I am having is that it only allows one person to run queries involving this excel table.
I'm getting the following error message.
"The Microsoft Access database engine cannot open or write to file ********.XLSX. It is already opened exclusively by another user, or you need permission to view and write it's data"
Is there any way to work around this? I would like every user to be able to run these reports/queries.
Thank you.
I have a split database that I have implemented, have about 3-4 people using it. One of the tables in this database is a linked table with excel. The problem I am having is that it only allows one person to run queries involving this excel table.
I'm getting the following error message.
"The Microsoft Access database engine cannot open or write to file ********.XLSX. It is already opened exclusively by another user, or you need permission to view and write it's data"
Is there any way to work around this? I would like every user to be able to run these reports/queries.
Thank you.