Problem with back end locking

[suepowell]

HI..
I have a multiuser database split front end back end as it should be.

Up to now I have had all users opening the same front end from a networked drive and of course pointing to the same backend.

I want to move to each user having their own front end on their own PC, and have produced some scripts to ensure they are always using the latest version.

My problem is this. with the users having their own frontends, as soon as one person opens the database the backend becomes read only for everyone else.

I am using access 2007, can anyone point me in the direction of the option I need to set to allow the backend to be opened from multiple frontends at the same time. This applies to the whole backend, not just specific forms or tables.

Thanks in anticipation.

Sue

 

[jsv2002]

Sounds like a network problem and not an access problem assuming that the settings in the database are to open as shared and not exclusive.

Is the backend stored on a network drive that is mapped on all the local machines connecting to it? Have the relevant permissions for people connecting to the drive been setup eg. read/write. You don't state what type of network its is, simple windows netowrking or a server with logons for connected PC's.

good luck John

 

[suepowell]

Hi John

Yes the drive is mapped to all machines and they have relevant permissions.

Anyone can open it if they do it first, but if someone already has it open the next person gets it read only.

You say assuming the settings are to open as shared and not exclusive.

This is what I want to find out, I knew wherer these settings were in previous version of access but can't find them in 2007 so this may well be wherer the problem is. Do you know where to set the database as shared and not exclusive in access 2007.

Thanks

Sue

 

[jsv2002]

From the start "globe" you should see a button at the bottom for access options click that then goto the advanced tab scroll down to the advanced sub heading and you have the default open mode, shared or exclusive.

Hope it helps John

 

[suepowell]

Hi John,

Thanks for that.

I've checked and it looks right, so I'll have to do some more digging. I'll look at the permissions on the folder as well to see if there is anything odd there, at least that gives me something else to look at.

Thanks for your help, and if anybody else has had this problem with access 2007 and solved it I would be very glad to know what caused it.

Sue

 

[jsv2002]

I had similar problems with a Server 2003 installation and found that setting the database up in its own root directory solved the problem of record locking (obviously setting the permissions on the directory as required)

Regards John