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.

I think you may have insufficient rights to some parts of your code. When
logging in as admin you should be able to assign administer rigths to all
objects in the database (Including the new item entry) When shipping the
application you should ast a password on the admin user to prevent the
users from getting access to the development environment.

Also you need to ship the system.mdw that was used to set up the security
originaly with the application

Niels