Question Locked

Problem with Sharing in Excel linked access database

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hiya,
I have created an access database with table linked from Excel. There is only one user who has full control of Excel file. There are many users in the office who can open the Read-Only access database to view reports.

The problem i face is, when an user opens the access database anywhere, no other user is able to open it. Even the admin is not able to open the excel file to edit the excel data.

Can you help me please?

thanks

5 replies

by hal 9000

Access is only a Desktop application and doesn't support multiple openings of the same file in any form. Once one desktop has the file open that's it for everyone else.

You need to use a DBase on the server and allow access though that to the desktops and not through Access.

Col

by sxviswan

Access is a multi user application. It can support about 10 to 20 users depending on what task is being executed.

It is the linking to the excel table, which is the cause of to Access to locking to exclusive use. This may be a problem that MS has to address.

In my case sometimes either Excel or Access crashes and sends a report to MS.

Hope to see a patch that will fix this.

Sajit

by robert_1980

If your data resides in Excel, you might want to use Excel collaboration tools directly without adding MS Access to the mix. You can do it yourself or have it done professionaly. I use OfficeSoftworks, a UK outfit I trust. Ask for Jake if you want the developer I dealt with. You can find them on any of those sites: http://www.OfficeSoftworks.co.uk
http://www.AccessExpert.co.uk
http://www.Excel-Expert.co.uk
http://www.Expert-Excel.com
Good luck,
Robert

This discussion is closed to new replies.