Startup form bypass security password

[stevefishwickuk]

Hello,

I have a db that I want to password, so that anyone pressing either F11 or holding shift down at the start, will be prompted with a password.

.....But, I want the user to be able to see the start-up form and associated forms without having to enter a password.

Is this something that is possible to do in Access97?

I have searched the forum for an answer, but can't find anything.

Thanks, Steve.

 

[namliam]

You can disable the F11 and shift key, eliminating that option all together....

And posting a question once is usually enough to get an answer on this forum...

 

[stevefishwickuk]

But how would I be able to get in then?

 

[AccessJunkie]

Hi Steve,

I have a db that I want to password, so that anyone pressing either F11 or holding shift down at the start, will be prompted with a password.

.....But, I want the user to be able to see the start-up form and associated forms without having to enter a password.

I'm confused. Those two sentences are contradictory. You want a password when the database opens, but you don't want them to enter a password???

Can you re-word what you are trying to do? Maybe then we can offer some suggestions.

Review this page on my site for code and utilities that will enable/disable the shift key bypass.

http://home.bendbroadband.com/conradsystems/accessjunkie/shiftkey.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

 

[Bat17]

You can secure the DB using user level security to do it. here is an excerpt from the Microsoft FAQ http://support.microsoft.com/?scid=http://support.microsoft.com/support/access/content/secfaq.asp ( the link seems to be down at the moment)

8. How can I secure just my code without users having to log on?
This works by using two separate workgroup information files: one for development and securing your database, and one for distribution. You can even use the default System.mda/mdw for distribution.
1. Secure your database completely by following the steps discussed in Section 1, "What are the steps to secure a database?"
2. Make sure that all permissions to modules are revoked for the Users group and the Admin user. (If you have used the Security Wizard, this is already taken care of.)
3. Grant full permissions to the Admin user and the Users group for all the objects that you want everyone to be able to use.
4. Distribute your application using the default workgroup information file. Because there is no password assigned to the Admin user in the default System.mda/mdw, everyone logs on as Admin and everyone has only those permissions you have assigned the Admin user and the Users group.
When you need to make modifications to your application, you need to switch to your development workgroup database and log on as the owner of the database.
Beginning with Microsoft Access 97, a database can be converted to an .mde file. This removes all editable code from the database and makes the design of forms, reports, and modules inaccessible to users. It has no effect whatsoever on data or on linked tables. The account creating the .mde file must own or have Administer permission to the source .mdb file.

HTH

Peter