Form does not exist

[Trevor Bourne]

From time to time, like just now, when I try to open a
particular form in my Access97 database I get the
message "The form name 'REPORTS' is misspelled or refers
to a form that doesn't exist".

The form with that name appears OK in the database window.
When I attempt to open it in Design view I get the same
message as above.

When I try to delete it or re-name it, I get the
message "The save operation failed".

When I try to over-write it with the same form out of a
backup copy I get the message "The save operation failed"
followed by "Name conflicts with an existing module,
project or object library".

Other times the form opens OK.

This has me baffled. Can anyone please suggest what is
causing this and how I might overcome it.

Will very much appreciate your reply.

 

[Steve Schapel]

Trevor,

I would suspect some type of corruption in your database. The first
step I would take is to make a new MDB file and import all database
objects into it from your existing database, compile all code, and
compact the database. The next step would be to rename the form
Reports to something else. The word 'reports' is a reserved word in
Access (i.e. has a special meaning), and should not be used as the
name of a field, control, or database object.

- Steve Schapel, Microsoft Access MVP

 

[trevor bourne]

Thanks Steve

I suspected something along those lines i.e. an
unfortunate choice of name for the form, causing a
conflict.

Will follow your recommendations and see how we go.

Cheers
Trevor