Unable to open VB Code Win after Securing DB 
Author Message
 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.



Sat, 04 Sep 1999 03:00:00 GMT  
 Unable to open VB Code Win after Securing DB

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



Sat, 04 Sep 1999 03:00:00 GMT  
 Unable to open VB Code Win after Securing DB



Quote:
> 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

I was logged on as Admin with every permission to every object in the
database.  I also owned all of them.  Anyway, Access still shouldn't crash
if I try to access an object which I have no permissions to read - at the
very least, I should just be gettinga dialogue box which tells me that I
have no permissions to read/ alter the object in question.  I shouldn't
have to ctrL-Alt-Delete out of Access and restart the entire application.


Fri, 10 Sep 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Unable to open VB Win after securing DB

2. Code to Open DB using a secure workgroup?

3. Can't open secure Access 2.0 DB from VB 4.0

4. accessing records in one secure DB from another secure DB - programatically

5. Opening Secured Access DB in Crystal

6. Opening Secured Access DB in Crystal

7. Open a secured MS Access 97 db in VBScript

8. opening secured Access db

9. Pb opening secured Access97 DB

10. Open Secured Access DB

11. Trouble opening secured access db.

12. Opening Access db with secure .mdw file

 

 
Powered by phpBB® Forum Software