Locked out

[aronw]

I created a DB a while ago, now coming back to it I want to make some changes to it. However i'm not allowed. Firstly if another network user is using the same DB it says,
"Couldn't save; currently locked by user Admin on machine ..."

Secondly, when every other instance of the DB is closed i'm told that the tables are read-only and I cannot create new fields. Oddly given about 15 minutes with only 1 copy of the DB open I can write to it again.

These maybe simple problems however i'm still relatively new to Access and have not met these ones before. Anyone?

TIA

Aron

 

[Ally]

If the other user is using the particular object etc that you wish to make changes to you won't be able to make any changes to the design until they have come out of that object. Even if they are using a form / report, you won't be able to make any changes to the underlying table / query.

If it's only "writing" changes you wish to make, you need to check your Record Locks because if you've got it set to all records, that can cause problems. You'll not be able to make any changes when another user is in any of the related objects. I always find that setting it to "Edited Record" is best.

If you've not done anything with the record locks and you're not sure what I'm talking about, you need to go to Tools > Options > Advanced and tick the Edited Record box. Also, set Default Open Mode (to the right of the Default Record Locking, and check the box "Shared".

HTH

 

[aronw]

it is strange...

My default record locking was and is set to 'No Locks' and my default open mode was shared.

Is that always the case, (if another user is using) is there a way around this. I'm not very Access knowledgeable yet but I have setup this DB and about 6 people are using it. I get all sorts of phenomena, e.g. records not saving correctly. ?
Like the monkey,

TIA

Aron

 

[Ally]

Hmm. That's blown that theory!

If you're going to have more than one user, it's a good idea to have Edited Record checked, rather than No Locks as otherwise, you can have conflicts in amendments.

It may be an idea to check it on the form that the locks haven't changed for that. In design view, view the properties list for the form, and not far from the top there's Record Locks. Check to make sure that that's not got All Records on there.

Whatever, you won't be able to make any changes to the design if there's someone else making write changes to the form. You will need to get them to come out of the database (or object/s you wish to change) in order to get any further.

Re the other problems - I think these may be helped by you changing the Locking system to Edited Record. If it doesn't make any difference, I'm afraid I don't know, but post back and someone else should hopefully be able to help.

The monkey ... he's actually an orang-utang (called Clyde!)

 

[aronw]

just to check,

Thanks, have changed the global record locks setting to 'editted locks' you mentioned checking the record lock properties for the forms. Just to check, where you suggesting these be changed to editted as well? They are also currently on 'no locks'.

One of the main conflicts seems to cause the same field on two different forms to overwrite itself.

TIA

Aron