Locked Object

[Averil Pretty]

Hello,

I work on a database from home and then email it to myself
at work so I can work on it here. I then save the
database and make sure that it is not read only.

Lately, for some reason three of the forms now have an
error "The object is locked, so any changes you make will
be discarded when the form is closed" Saving As or
Exporting does not fix this problem... Any ideas as to
what might be causing this? When I go home and open it up
again it's fine.

The other thing I have noticed is that I can no
longer "nudge" objects on any of my forms (including the
ones where I don't get an error) using the keyboard
arrows.

Any help would be much appreciated!

Regards,
Averil

 

[TC]

What version(s) of Access?

Has the database been secured with user-level security?

What exact action causes the error you mentioned, to appear? When you open
the form in normal view? in design view? ...?

Are you certain that that is the full & exact text of the message you're
getting?

TC

 

[Averil Pretty]

Hi TC, thanks for trying to help.

I have Access 2000 at work and Access 2002 at home so
maybe the problem lies therein... though I haven't had
trouble before.

The error comes up when closing the form in form view. I
should mention that the error comes up 4 times, which is
how many graphs there are on the form (the form is
basically just the graphs). I have checked the properties
of the graphs and they are not locked as far as I can tell.

The full and exact text of the error is:

"The object is locked, so any changes you make will be
discarded when the form is closed.

Click Save As/Export on the file menu and save the object
under a different name"

I did try and Save As and Export and I still got the
problem :-(

I'd appreciate any help as I have to get this finished for
a meeting next week and still have other things to add to
it.

Regards,
Averil

 

[TC]

Hi Averil

This error is a new one on me.

I believe you can fix it with one of the following options. Try them in the
order shown, until one works for you. You should only need one - not all
three.

1. Set the Enabled property of the graph control, to False.

2. Import all the objects from your database into a fresh new database, &
try again.

3. Add the following event to your form:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 2800 Then Response = -1
End Sub

I believe that option 1. should fix it. Please post back & confirm if it
does.

HTH,
TC

 

[Averil Pretty]

You are an absolute legend!!!!

You're right, option 1 seems to work. I wonder why this
would be though???

Thanks again for your response.

Regards,
Averil Pretty

 

[TC]

Thanks

No real idea why it would happen.

TC
(off for the day)