Demo Database has an error - need help ASAP

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

Getting ready for big demo tomorrow. Database has seven major forms called
from a switchboard. 6 out of 7 behave correctly. The 7th (and, of course,
the first on the list) does not behave correctly.

From the switchboard we select this form. Go off and do things with it. When
we close it is should just go back to the switchboard. Instead it shows this
message:
"The object is locked, so any changes you make will be discarded when the
form is closed"

The question is - what causes this message to be displayed?

I set a breakpoint in the debugger to see if it reaches the code when you
click on the button to close the form. Never gets there. Just shows the
above message. I was hoping I could use DoCmd and turn off/turnon warnings
but as it never gets to the code, the warning appears.

These things always happen the day before a demo. What can I do to fix
whatever is the problem?
 
Have you checked the Data tab on the form's property sheet?Perhaps Allow
Additions is set to No?
 
No joy in Mudville.

No change in the behavior. I tried it both ways - setting it to allow
nothing - no edits/deletions etc. then did a 180 and set it to allow
everything. Even did a Compact and Repair.
 
Appears to be a version control problem. Works first time, every time on
Access 2003. Machine I was testing on had Access 2000. Why? Right now I'm
happy that it works and we can do our demo.

Thanks to BruceM for his help.
 
You could try exporting your database objects into a new, blank database.
That helps sometimes. Glad to hear you got it working in time.
 
We did do the process of creating a blank database and importing everything
into it. I also ran a Compact and Repair. The error still occured.

The form itself is very complex. Somewhere I suspect there is an offending
object but I'm not sure how I'd track it down. I can't do it in the debugger
because the error never gets to the code breakpoint I set in the On Close
event.

For now we're content it works in 2003. I'd still like to know what the real
problem is but I'm being told to move on.
 
Does the form contain controls of a type not found on the other forms (e.g.
charts, graphs)?
You might try searching for your error message in Google Groups. Lots of
hits when I typed it in, but I did not look very closely. You have tried
most of the suggestions I saw, but I did read in a couple of places that if
the answer to the question above is Yes, set the control's Enabled property
to No.
 
Back
Top