Access bug cause error?

[sysgeo]

On our database we have a subform in the main form. We are getting the error '"The database has been placed in a state by user..." when this form is opened on two or computers. the database is network shared mode, 2002 format and we are using access 2003.

Reading this support page on microsoft.com (http://support.microsoft.com/default.aspx?scid=kb;en-us;248967) suggests that the bug was fixed in 2000.

Can someone please help me or suggest a fix.

This is doin my head in . . .

Steve

 

[quest4]

Have you installed all of the Sevice Packs for Access and Jet? Also you may want to try to reboot the computer. That is the Bill Gates cure-all. hth.

 

[sysgeo]

2003

But we're using Access 2002 and 2003, surely this bug was fixed in the later versions?

 

[quest4]

Never assume anything, especially with MS. Their philosophy is is get it to market and make the money on it and if MS is lucky they will fix it in an SP. As a last resort, try changing, both ends, the name of the dbase. Then create a new blank dbase and import everything into it and then run C&R, repeat for the other end. See it it works. hth.

 

[sysgeo]

Prices

When you're paying the bloated license fee for office 2003, you expect them to at least make sure the bugs in the previous version are fixed before new ones are found . . .

I'll take your advice and give it a go!!!

Cheers Steve o

 

[sysgeo]

just noticed

I have just noticed on the subform i have a macro on the 'on exit' to refresh the form

is this macro putting the form in a locked state so therefore the database is locked to all other users in a state?

Please help

 

[quest4]

Interesting, why refresh in OnExit? You would have to open the macro and read it, maybe there is something in it. I hardly ever use macros any more, except to run reports remotely. They don't upgrade very well and there is hardly anything that a macro can do that you can't do faster and better in code. Try getting rid of the macro and if you feel that you really need that Refresh, go into the OnExit property of the form and add it there. hth.

 

[sysgeo]

jumped the gun

I removed the command but the error is still there. It seems to lock people out after you've created the subrecords, then go back to the main record to amend / add some data in.

We also seem to get a screen about exclusize access to the database when one or more users are using the order system subform. very strange indeed . .

Anyone know what this is, would be very keen for a fresh pair of eyes to look over our work to see if they can see what the problem is . . .

email me

 

[sysgeo]

solved i hope

I have shown our database to a delevoper i know. She says the way to fix it is to rebuild the problematic form from scrach.

Hopefully this will solve the locking error we keep on expereniceing. And will help anyone in a similar situation.

Regards

Steve

 

[quest4]

Try to create a new dbase and import everything in it. Then do a Compile and a C&R. Close it and reopen it and see if the helps. If not then your friend is right, but only as the vary last resort. Sorry I could not be of more help to you. LOL.

 

[sysgeo]

cheers fella - luckly its not a major form

 

[sysgeo]

just as follow up - rebuilt the form - problem sorted

 

[Mile-O]

We are getting the error '"The database has been placed in a state by user..." when this form is opened on two or computers. the database is network shared mode, 2002 format and we are using access 2003.

I take it you have no split the database into a front end and a backend?

 

[sysgeo]

yes the database is split but the error [described above] happened on the front end part.