Form won't open - intermittent problem

  • Thread starter Thread starter hammerb
  • Start date Start date
H

hammerb

Have an Access 2000 database that works great but every so often (3 to
6 weeks) I will click on a particular form button on a switch board
and I get this message "There was an error executing the command". All
the other forms work properly. I come out of the switch board and go
to the regular form area and when I click on that form nothing
happens. This form is linked to a sub (detail) form that also does
nothing when I click on it. If I go to the "display code" window of
another form it shows the code attached to that form but when I click
on the troubled form all the code is gone and I "guess" thats why the
form won't load. I cannot even get the form to display in design
mode. My remedy is to delete both the main and the sub form and then
go to "get external data" and import the main and sub form from
yesterday's backup and everything is okay for another 3 to 6 weeks and
then the problem reoccurs.

I hope there is someone out their that can help or steer me in the
right direction to solve this problem. I have done VERY little VBA
programming. Thank you.
 
Do you compact regularly? Any chance this is a monolithic multiuser
database, or a split multiuser one, with all users sharing a common copy of
the FE?

Nikos
 
Back
Top