Error Adding New Records - DB Locking?

[Simmo2010]

Hey peeps,

Hoping you can help me out with a problem I have... Basically every now and again I get a call from my client saying they cant add a new record, to any table, they get a message saying they are not allowed. I go in and it seems the DB has somehow locked itself and I have to open it up and repair it... it is a multi user setup with the database on a server.... I have seen the users actually end task on Word if it doesnt respond quick enough and was wondering if this would cause the locking problem!? I am just asking to see if there is a setting or something I can do to try and prevent this happening!?

Any help at all much appreciated!!

Thanks

Matt

 

[winshent]

Is the error message something like 'Object Error - Read Only Object'..

I had a problem like this where the back end mdb had become read only, even though all users had closed down the front end app. I had to ask Domain Admins to kill all connections to the file.

I put this error down to a network problem, as our network would perform better if it was made of string !!

 

[Rabbie]

Hey peeps,

Hoping you can help me out with a problem I have... Basically every now and again I get a call from my client saying they cant add a new record, to any table, they get a message saying they are not allowed. I go in and it seems the DB has somehow locked itself and I have to open it up and repair it... it is a multi user setup with the database on a server.... I have seen the users actually end task on Word if it doesnt respond quick enough and was wondering if this would cause the locking problem!? I am just asking to see if there is a setting or something I can do to try and prevent this happening!?

Any help at all much appreciated!!

Thanks

Matt

Is your DB split into FE/BE. If not you need to split it straight away. Several users using the same unsplit database and endtasking will cause lots of problems.

 

[Simmo2010]

It is already split and the problem is as Winshent said it is showing as read only!? I moved it to another share that people read/write from all the time and is working now now! Fingers crossed!

 

[gemma-the-husky]

when you say split, does each user have a SEPARATE copy of the code database - they still shouldnt all be running a netwrok copy

in fact i put code in mine to check the drive letter, and not open if its above, say, G

 

[Simmo2010]

I have one copy of the "database" on the network share. Then each user has a front end with linked tables to the network share.