Access opens all non-tables in exclusive mode because it needs to be able to allow you to update them. [\quote]
I am getting the same error message that the Excel file is not available.
Have I misinterpreted what you are saying? In my db I pull from 3 tables that are Access resident, 4 ODBC AS400 linked tables and 1 linked excel spreadsheet. All of these are pulled together in a query which my form is based upon.
The db is set to shared and I am just double clicking the shortcut so I'm really perplexed as to what could be the problem.
I tried to TransferSpreadsheet import but I get error that the "Operation must use updateable query". If I have the owner of the other db do a TransferSpreadsheet export on db close then I could do a TransferSpreadsheet import?
