Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 28th, 2006, 05:54 PM
Authorized User
Join Date: Jun 2006
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Startup Options/Database Password


I have a database with certain startup options for the end user. What I would like is for the database to prompt for a password ONLY IF the shift key is used to try and bypass the startup options, so that only an authorized person with the password can see the background of the database. If I simply set a database password from the Tools menu, it asks for that password with the startup options as well, and I actually locked myself out of a database that way! So there needs to be some kind of check for whether or not the user attempted to bypass the startup options, and based on that, ask for a password or not. I am not sure if I can do this through Access options directly, or I will require some coding, but either method is fine.

Please help!

Thank you,

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to startup database - Chapter 3 michaeltan80 BOOK: Beginning Spring Framework 2 ISBN: 978-0-470-10161-2 2 April 22nd, 2008 01:02 PM
Startup Options/Database Password kritimehrotra Access VBA 0 July 28th, 2006 05:49 PM
Database options changed on Audit Login ocliff SQL Server 2000 1 January 12th, 2006 03:07 PM
startup options mjuliao Access 4 November 22nd, 2005 04:45 PM
Cannot open database with password saikrishnan Pro VB Databases 0 August 26th, 2005 01:47 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.