inconsistent error msg when trying to close/save

jan001

Board Regular
Joined
Jul 22, 2004
Messages
123
Our office uses an Access (2003) db to manage our field projects, using a customized form created in early 2003 by someone who no longer works here. This morning, a user reported that she is unable to save any changes to any of her projects. She is able to open the db and make her changes but whenever she tries to print, manually save (using the toolbar icon), or save by simply closing the record, she gets "Could not update - currently locked."

I had her try three separate records at random and she had the same results. I had another user try the same records and he was able to save fine. I tried them myself and - to keep things interesting - I could save two of them, but not the third.

I have a theory on what might be wrong but am not super-confident of my Access abilities, which is why I'm here. Obviously it's been a long time since I've had to manage an Access db. I've used Crystal Reports more recently and even that's been a couple of years ago now. I was just assigned full responsibility for this db about 6 weeks ago. Everything's been fine till now. Two days ago, the boss ordered several changes to be made to the tracking form mentioned in the first paragraph.

Being a firm believer in not reinventing wheels that are already rolling, I opened the form and saved it with a different name and proceded to start making the changes to the newly-named version. It so happens that the initial record, from which I saved the new version, is one of the ones we're having trouble with this morning. This is as far as my diagnosis goes... did I gorm something up when I saved a live record's form to a new name? The original is still in place with all its data and comes up on Find, etc.

The only reason I question whether my saving/renaming technique is not to blame is that the other records she couldn't save either, plus the fact that at least one user CAN save changes on those other two records.

There's also the fact that the user who can't save anything said she definitely DID successfully save changes yesterday on one of the records she now cannot save. It is not the record I saved a new version of the form from.

Even if my save-and-rename is to blame for all this somehow, I don't know how to fix it. Is it as simple as deleting the saved-renamed version and building it from scratch?

I'm braced for the possibility that I did mess something up at some level by saving and renaming a form, although I've done that with other MS applications for years with no problems. Even if that is a problem, though, it doesn't seem like it could explain everything.

I've gotten great Excel help here for a couple of years or so, and I remembered that this board has an Access forum, so this is the first resource I've come to, with hat in hand. Any/all thoughts or suggestions will be greatly appreciated!

Signed, Going in Circles
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
Before doing anything else, have everyone exit the application and then you open it, click on Tools/Database Utilities/Compact and Repair.

Then have previous user check same record... see if problem still exists.

Compact and Repair should be set in Tools/Options/General/Compact on Close.... ALWAYS.
 

Forum statistics

Threads
1,136,269
Messages
5,674,743
Members
419,525
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top