Linked Excel Worksht Opens Exclusive

[rbehnke]

Situation:
Networked Access 2003 database.
Back end on the server, includes
an msd table and a linked excel worksheet
Front end on users computers, includes
forms, queries, reports.

Problem: The linked Excel worksheet displays on the FIRST
user PC, but not on any other. The error says
the Excel worksheet is already opened and is in
EXCLUSIVE mode.

QUESTION: What needs to be done to have the EXCEL worksheet
open in non-exclusive mode?

from Thread700-1289879

I have the same problem and could not determine if a solution was found.

The spreadsheet is NOT protected and is SHARED.


Thanks.

 

[PWise]

is the front end linked to each front end ?

if not how are you accessing theh spreadsheet

 

[rbehnke]

Yes, you are correct.

 

[PWise]

what i ment to ask is "is the spread sheet linked to the front end?

 

[rbehnke]

I had responded, but I don't see the response here.

Yes, that is the way I have it set up. I don't think I can link any other way.

Thanks.