Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Security

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-27-2009, 03:03 PM
dollygg dollygg is offline Windows XP Access 2003 (version 11.0)
Novice
 
Join Date: Jul 2009
Posts: 23
dollygg is on a distinguished road
Default how to secure mdb file?

The users could easily go into the back end of the databse by pressing Shift + Open. How to add more control into this to protect the tables , forms and query and reports?
Reply With Quote
  #2  
Old 07-27-2009, 03:16 PM
RuralGuy's Avatar
RuralGuy RuralGuy is online now Windows 7 Access 2007 (version 12.0)
Administrator
 
Join Date: Mar 2007
Location: 8300' in the Colorado Rocky Mountains
Posts: 4,322
RuralGuy will become famous soon enoughRuralGuy will become famous soon enough
Default

Disable the ShiftBypassKey and then start a form that shows a warning and exits the mdb.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
Reply With Quote
  #3  
Old 07-27-2009, 04:05 PM
dollygg dollygg is offline Windows XP Access 2003 (version 11.0)
Novice
 
Join Date: Jul 2009
Posts: 23
dollygg is on a distinguished road
Default

if the shiftbypass key is disabled, then how the database administrator go into the back end of the database?
Reply With Quote
  #4  
Old 07-27-2009, 04:36 PM
dollygg dollygg is offline Windows XP Access 2003 (version 11.0)
Novice
 
Join Date: Jul 2009
Posts: 23
dollygg is on a distinguished road
Default

Oh! I found the code to disable /enable the shift by pass key. Thanks for your hint!
Reply With Quote
  #5  
Old 07-27-2009, 05:34 PM
RuralGuy's Avatar
RuralGuy RuralGuy is online now Windows 7 Access 2007 (version 12.0)
Administrator
 
Join Date: Mar 2007
Location: 8300' in the Colorado Rocky Mountains
Posts: 4,322
RuralGuy will become famous soon enoughRuralGuy will become famous soon enough
Default

You're welcome. I guess we're ready for the Solved thread tool now right?
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upload file inside .mdb database file havish Access 0 07-30-2008 05:35 AM
Possible to export *.mdb file to *.exe file? slpuiwan Import/Export Data 1 12-16-2007 03:52 PM
How do you export a file with a unique file name Budman42 Import/Export Data 1 10-15-2006 04:10 PM


All times are GMT -8. The time now is 01:32 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.