logon dialog box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

developing an application for a client using access 97 and need to make the application totally secure.

when you logon, you get a dialog box for the password. if you hit cancel, you have access to the toolbar
that appeared as part of the logon procedure. you now have the ability to create a new database, open a
database and various other functions.

how do i deactivate that bar or somehow when cancel is chosen to prevent a user from getting to
that bar?
 
Use the On Load event of the logon form to run the
following code:

For Each tlb In Application.CommandBars
If tlb.Enabled = True Then tlb.Enabled = False
Next

Just make sure you also run these two lines:
Application.CommandBars("Menu Bar").enabled = True
Application.CommandBars("Database").enabled = True
before you close the application (e.g. on the On Close
event of your application's main form), so they are
available next time you run Access!

HTH,
Nikos
-----Original Message-----
developing an application for a client using access 97
Click to expand...
and need to make the application totally secure.
when you logon, you get a dialog box for the password. if
Click to expand...
you hit cancel, you have access to the toolbar
that appeared as part of the logon procedure. you now
Click to expand...
have the ability to create a new database, open a
database and various other functions.

how do i deactivate that bar or somehow when cancel is
Click to expand...
chosen to prevent a user from getting to
 
you mentioned a logon form

what i get is a dialog box that indicates password required, place to insert password and the
respond ok / cancel
in the background is a blank screen that has at the top 'file edit view insert tools window help
this bar becomes available when you hit cancel
this is what i get with the standard data base password assignment in access
i do not see how i can override this with a logon screen

thank
 
OK, it seems the logon is not performed through a custom
form, as I had expected. From what you're saying I
understand it must be using an inputbox, the process being
controlled by some code (or, less likely, a macro).
If it's code, then just insert the three lines of code to
hide the toolbars somewhere at the beginning of the sub.
If it's a macro, make a sub with this code and run it from
the macro (RunCode).

HTH,
Nikos
-----Original Message-----
you mentioned a logon form.

what i get is a dialog box that indicates password
Click to expand...
required, place to insert password and then
respond ok / cancel.
in the background is a blank screen that has at the
Click to expand...
top 'file edit view insert tools window help'
 
Back
Top