Multiple users in a db with linked Excel tables 1

[Loktar]

Hello guys and gals,

I'm having a problem with a db I'm developing that needs to be used by many users at the same time. Right now, most of the data in the tables are linked to Excel files. This allows for easy updates, which are required every day. The problem I'm having is that when multiple people try to use the db it gives this error:

The Microsoft JET database Engine cannot open the file:'\\Server\excelFile.xls'. It is already opened exclusively by another user, or you need permission to view its data.

I setup the Excel file to be a Shared Workbook so it can be used by multiple people, but this didn't help.

Has anyone run into this problem before, or have any ideas how I can fix this? I thought about splitting the db, but I don't see why that would change anything in this case.

Thanks in advance!

 

[psemianonymous]

This is basically not possible directly linking to Excel.

I answered this question a while back: thread702-807027

Basically I said "try importing the data into a temp table daily. If that's too much, then keep the data in the temp table and EXPORT to Excel daily, if you need the info in excel for any reason."

 

[Loktar]

Thanks for the quick reply. I was thinking of making a temp table, but was hoping that there was a way to make it work without needing that.