These options let you determine specific behaviors when the database opens. Two of these features lend a hand toward securing your database: Display Database Window: Deselect this option, and the next time someone opens the database, Access will hide the Database window. Users won't have immediate access to any objects. Figure A Set Startup options to hide the Database window. Bypass the bypass To close the bypass crack, set the AllowBypassKey property to False when the database closes.
Editor's Picks. The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script.
TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble. Comment and share: Hide the Database window to help protect your Access data. Show Comments.
Hide Comments. My Profile Log out. Join Discussion. Most Points The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.
Join our community to see this answer! Unlock 1 Answer and 6 Comments. Andrew Hancock - VMware vExpert. See if this solution works for you by signing up for a 7 day free trial.
What do I get with a subscription? With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Who are the certified experts? How quickly will I get my solution? This forces the Database Window to be the current window and the second line then hides that window. This trick is more difficult but it is still possible. The screenshot opposite shows an Access form floating on top of the Windows desktop with no sign of the main Access window. The only clue telling us that this is Access is the fact that there's an Access form icon in the title bar.
With a little more effort I could have changed that icon and made this look like a real Windows application rather than "just" another Access database. This switchboard is the first form that will appear when the user opens the database but it is not the main form of the application.
There is another form and this is where the work is being done. Its only job is to make a call to the Windows API when it opens. There are no controls on this form and the user will never see it but it must have two of its properties set:. It must also be set as the main form of the database in the Access start up options. There is one last piece of code to be added but this must be added to the user's form rather than to the hidden startup form.
It's needed so that Access will close when the user closes their main form. The technique will appear to work without this last bit of code but what you won't see is that Access itself will still be running.
We have to make sure that Access will be closed down when the user closes the form and the way to do it is to add this line to the Unload event of the switchboard form:.
0コメント