personalising password popup

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hey,
Im doing an ICT qualification making a system using access
(unfortunatly), and I would like to put the company logo
in the pop up asking for the password (i believe i have
passworded the whole database, it only asks for the
password once when you open the project).

Just wondering if its possible, if not can someone tell me
how to make a form that would only allow you to progress
to the switchboard (using a macro) once a certain password
has been entered - id think it was something to do with
the validation set up at the table level.

Any ideas please e-mail me - (e-mail address removed)

CHEERS
 
Ben said:
Im doing an ICT qualification making a system using access
(unfortunatly),

Mmm. Maybe not the best way to encourage replies in a newsgroup devoted to
Access!

and I would like to put the company logo
in the pop up asking for the password

No can do, afaik. There is an option somewhere in Tools : Startup (?) to
select a custom icon for the application. That icon appears in various
places. But I think that it does not appear on the password popup. (But I
don't have Access here to check, so it might be worth a try.)

(i believe i have
passworded the whole database, it only asks for the
password once when you open the project).

Be aware that the database password for Access 97 & earlier is easily
cracked using code that is freely available on the web.

Just wondering if its possible, if not can someone tell me
how to make a form that would only allow you to progress
to the switchboard (using a macro) once a certain password
has been entered - id think it was something to do with
the validation set up at the table level.

No, that would not be how to do it. The form should prompt the user for his
username, password, or whatever other values you want to prompt him for -
see InputBox(). Then it could use DLookup() to check for those values in a
password table that you had established; or it could check against "hard
coded" values stored within the form itself. But unless you are careful,
your home-grown security scheme will be easily cracked. Is it worth doing
this work (and taking that risk), jst to get a logon on a momentary password
popup? I'd go with the Tools : Options method, myself.
Any ideas please e-mail me - (e-mail address removed)

"Ask here, answer here". This is so that everyone can benefit from the
answers provided.

HTH,
TC
 
Back
Top