T
Tim
Something has gone awry with my Access 2000 database.
Here's the scenario:
I delete a form (which had some code behind it) in the MS
Access database window.
I open Project Explorer, and the form still appears.
I click on the form in the Project Explorer, and get a
message saying "... refers to a form that doesn't exist",
which makes sense.
Then, and this is the troubling part, as I click on other
forms in the Project Explorer (that still exist), I
eventually get a message saying "Error accessing file,
network connection may have been lost". (The app is being
deployed off a network server, and I am pretty sure my
network connection is perfectly OK.)
As an experiment, I used the MS Access wizard to build one
of the "stock" databases that ships with Access 2000. In
this database, when I deleted a form from the MS Access
database window, it was also automatically deleted from
the Project Explorer. No problems.
A couple other things. If I try to delete a form from the
Project Explorer window first (instead of from the MS
Access database window), I can't. The command to delete
the form is grayed out in Project Explorer, which seems
strange to me.
Also . . . I thought maybe my mdb container had gone
corrupt. So, I opened a brand new mdb file and imported
all my database objects into it. No change. Same behavior.
Also . . . I have also noticed that once I delete a form
in MS Access database window, I can't compile the code
anymore. I get the "lost network connection" message.
Also . . . At one time, in the act of creating a new
database by importing all the objects from the bad
database, I got a message like "MS Access cannot create
the VB module". (Memory's hazey on this one.)
So, it seems to me that MS Access is not communicating
with the Project Explorer like it should.
The problem has the potential to seriously complicate my
life. Any help would be greatly appreciated.
Here's the scenario:
I delete a form (which had some code behind it) in the MS
Access database window.
I open Project Explorer, and the form still appears.
I click on the form in the Project Explorer, and get a
message saying "... refers to a form that doesn't exist",
which makes sense.
Then, and this is the troubling part, as I click on other
forms in the Project Explorer (that still exist), I
eventually get a message saying "Error accessing file,
network connection may have been lost". (The app is being
deployed off a network server, and I am pretty sure my
network connection is perfectly OK.)
As an experiment, I used the MS Access wizard to build one
of the "stock" databases that ships with Access 2000. In
this database, when I deleted a form from the MS Access
database window, it was also automatically deleted from
the Project Explorer. No problems.
A couple other things. If I try to delete a form from the
Project Explorer window first (instead of from the MS
Access database window), I can't. The command to delete
the form is grayed out in Project Explorer, which seems
strange to me.
Also . . . I thought maybe my mdb container had gone
corrupt. So, I opened a brand new mdb file and imported
all my database objects into it. No change. Same behavior.
Also . . . I have also noticed that once I delete a form
in MS Access database window, I can't compile the code
anymore. I get the "lost network connection" message.
Also . . . At one time, in the act of creating a new
database by importing all the objects from the bad
database, I got a message like "MS Access cannot create
the VB module". (Memory's hazey on this one.)
So, it seems to me that MS Access is not communicating
with the Project Explorer like it should.
The problem has the potential to seriously complicate my
life. Any help would be greatly appreciated.