Please Help - Sharing Problem in Access 2007

[DavidN]

OK, I have spent the best part of a week trying to sort this out, so if anyone can shed any light on it, I would be very very grateful.

I have created a database in Access 2007, which I wish to share with my collegues. We all are running Vista, and access 2007, over a peer to peer network.

I have installed a Front End on each Computer and linking to one copy of the backend on the host computer in the public drive.

The system runs great on each PC, however, I am having a problem sharing the database. All users can log onto the database at the same time.

However, when one user enters a form, it locks access to the form for other users, it just hangs until the other user exits the form, then the user that was hanging goes directly into the form. I get no error message.

I have tried linking the form to a query rather than directly to a table, but no joy with that either, the form still allows only one user.

I am not sure if this is an exclusive permissions problem and I need to change the Windows security settings or something else.

Like I say, if anyone can help, it would be really appreciated.

 

[gemma-the-husky]

However, when one user enters a form, it locks access to the form for other users, it just hangs until the other user exits the form, then the user that was hanging goes directly into the form. I get no error message.

if you have really split the database and each user has their own copy of the forms, then it is not the form that is locked, but the underlying dataset/tables

are you sure you are not opening the forms in some sort of record locking mode - check the form design proerties, and underlying query design properties.

I wouldn't have thought it was a problem with the backend, since this is just supplying data, but it may even be a problem in the back end.

 

[DavidN]

Yes I have checked and all the forms are unlocked. I agree that it is not the form, but the tables that are linked to the form, that seem to lock once a user in in them. It locks all tables in the backend, not just the table the form is linked too.

I have read, that it could be the users have exclusive access, but not sure how I check if this is the case and how to make the amendments.

 

[gemma-the-husky]

perhaps there is a corruption in the backend

create an empty backend, make sure it is definitely set mutliuser, then import all the tables form the faulty one - see if that helps

 

[DavidN]

The database shows as shared and no locks. Is there another Multi User setting I need to adjust. Thanks for your assistance.

If not I will try and create a new database to test if corruption could be the problem.

 

[gemma-the-husky]

is the back end on a shared drive, - perhaps its something strange with the share thats causing the problem,

im not sure exactly what you mean by a peer to peer network, so perhaps that is the issue

 

[DavidN]

Yes the backend is on the shared drive. The peer to peer network is where we link all PC's via a router rather than a server. One of the PC's acts as the host, which has the public drive, and all other PC feed information from that.

 

[gemma-the-husky]

perhaps the router is limiting one user at a time to the back end - i'm not sure what effect that set up would have.

 

[Mike375]

If Bob Larson does not come on thread it might be worth alerting him. He has mentioned a few times about problems with Access 2007 and different settings that need to be done. Although I don't remember seeing this problem.

Like you I have the router and use both cable and wireless at the same time.

Just a stab in the dark but it might be worth making a new blank data base and then importing everything in. If you rename the new data base with the same name then all the table linking will be OK, at least it is on 2003 and earlier.

 

[DavidN]

Mike Thanks for the suggestion. I will give it a try.

 

[boblarson]

1. Make sure all users have full permissions in that folder that the backend is on.

2. Make sure that you: