
Unable to open VB Code Win after Securing DB
I hope this isn't an question which is asked too frequently... if it is,
sorry!
Anyway, I am currently developing a database for a small company in Access
95. I have finished, mostly the development, and, while not the epitome of
style, it worked. I then ran the security wizard, and set up user names
and passwords etc etc. These all work fine, except that I am now unable to
open VB Code Windows.
The problem goes like this. If I log on as the administrator, I go into
form design view of any form, and click on the ellipses (the "..." bit) to
open up the code windows for that particular event. I then get an "empty"
error message. If I click "OK" to this, then I get another one, and, if I
click OK to this one, the Access window goes blank, with the VB toolbar the
only one visible. The database appears to be open still - the title bar
hasn't changed back to MS Access - yet F11 does nothing. If I click on
File->Close Database, I get the vb toolbox and an empty form window
appearing - neither of which I can do anything to - and if I click on Close
Database again (the menu is still there), the toolbox disappears, the menus
return to the ones which appear when no database is loaded, but the form is
still on screen. This seems to apply equally to an event which occurs to a
form, and to an event which occurs to a command button on a form.
Occasionally, with certain events on certain buttons/forms, you can open
the form window as if nothing has happened.
I have run the database on several computers, and the problem recurs. I
have also tried an unsecured version of the database (a backup - the only
difference between them is that the one has had the security wizard run on
it), and everything works perfectly.
Anyway, any help with this problem would be much appreciated; I don't know
if my email address will be displayed properly in the headers, so it is
read!
Thanks in advance,
Cheers,
Andrew Bolton.