linked table in non-exlusive mode

[dizzyjc]

We have a networked database (using ACCESS 2003) containing:

two tables: 1 mdb table (Table A), and 1 linked table to an Excel worksheet.
the excel worksheet is set to be SHARED

FormA : uses Table A, and the linked table is used in a subform

SITUATION : Everything is Ok, if only 1 user opens FormA.
If a second user tries to use FormA, an error occurrs that the linked table is already being used and is in exclusive mode. The form will open but the Subform opens empty.

QUESTION : What needs to be done in order for the linked table to open in 'Non-exclusive' mode?

I'm a newbie to ACCESS, so any help will be greately appreciated.

Joel

 

[Uncle Gizmo]

I think your best approach would be to split your database into the frontend backend arrangement. There is much information within this forum on this. Do a search on frontend, backend.

once you have created your front end and back and put the backend on the server, and make a copy of the front end for each person using it.

Note:
Make the copies after you have linked the front end to the back end, and it should work from any machine on your network that has access to the same server.

 

[dizzyjc]

Thanks Uncle Gizmo, being such a newbie to Access, I'll have to research the frontend/backend concept.

 

[dizzyjc]

I separated the database into frontend/backend. Same result.

I placed the two tables, TableA and the excel worksheet, on the server.

The frontend has the forms, queries, subforms, reports, etc.. The frontend now is on each users computer. I get the same result. It works for the first user but the next user gets the same error (i.e. the excel file is already opened and it's in exclusive mode).

Any other suggestions? Is there a way to have the linked excel worksheet open in non-exclusive mode?

Joel

 

[Uncle Gizmo]

A stab in the dark really, but what if you link both front ends to the spreadsheet directly ?