+ Reply to Thread
Results 1 to 8 of 8

Thread: Database accessbility information

  1. #1
    ramez75
    ramez75 is offline
    Barn Newbie ramez75 is an unknown quantity at this point ramez75's Avatar
    Join Date
    Nov 2008
    Posts
    27
    Rep Power
    4

    Database accessbility information

    I have a database used for inputting cards. The database will be located on the network share drive were all employees can access it. The problem is I want the employees to access only the forms of the database.
    At this moment I disabled all toolbars using ShowToolbar "XXXXX", acToolbarNo NoToolbar during form loads also I protected the VBA access with a password. Also under the properties of the FORMS I selected NO for Shortcut Menu hence they cant use the right click on the mouse to go into the Design mode or any other mode.
    But using the F11 function will give the user the ability to access the forms and queries, design etc.

    I want to be the only one to access all these features of the database where all other users when entering the database they access the forms only key in their data and exit the forms/Database. They shouldnt have any right click ability, F11, Alt+F11.

    I looked into something User and Group Accounts but if I use that option then any other database opened the password thing is required. Also I want to avoid the password thing if possible I just want features to be in active when in as a USER and all features active when in as ADMIN or OWNER

    NOTE: the database i have now consist of 2 forms + 2 queries + 10 tables+1Macro and VBA codes within the forms.

    The USERS should only access the 2 forms

    Any help on this will be greatly appreciated. I dont have much knowledge about the security/workgroup. So if thats the only route to go I will appreciate some guidance in that domain

    Thanks
    ramez75, January 9th, 2009 05:00 PM
    Reply With Quote Reply With Quote
  2. #2
    AOG123
    AOG123 is offline
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    Hi welcome to developerbarn

    To disable F11 and Alt+F11 you want to go: -

    Tools
    Startup
    Advanced

    Then "check" box, Use special keys



    You'll also have options to disable items such show db window, and allow full menus on startup here.

    Next, you may want to disable the shift key on open,

    Use this attached sample database to acheive this,. as always backup your db before making changes.

    Important     Make sure you keep a copy of this sample db as you will need it to unlock the db next time you want to modify it.
    Attached Files
    AOG123, January 9th, 2009 05:26 PM
    Last edited by AOG123; January 9th, 2009 at 06:00 PM.
    If i helped you, make me famous by clicking the
    Reply With Quote Reply With Quote
  3. #3
    boblarson
    boblarson is offline
    Barn Regular boblarson will become famous soon enough boblarson's Avatar
    Join Date
    Jul 2008
    Location
    Portland, Oregon
    Posts
    66
    Blog Entries
    1
    Real Name
    Bob
    Rep Power
    4

    1. For multiple users on a network you really need to split the database to a frontend/backend.
    See here for more about that:
    Split Your Database

    2. Your users should have a copy of the frontend on THEIR machine and NOT be loading it from the network share. Corruption is highly likely if they are all opening from a single location, or even separate locations on the network. You will be less likely to suffer corruption when the users have a frontend on their machine which is connected to a backend on the network share.
    boblarson, January 10th, 2009 10:43 PM
    Bob Larson
    Access MVP (2008-2009, 2009-2010, 2011-2012)

    Free samples and tutorials: http://www.btabdevelopment.com

    Reply With Quote Reply With Quote
  4. #4
    ramez75
    ramez75 is offline
    Barn Newbie ramez75 is an unknown quantity at this point ramez75's Avatar
    Join Date
    Nov 2008
    Posts
    27
    Rep Power
    4

    AOG123, Thanks for your reply. Ofcourse I backed up my database and went to tools, StartUp and unchecked special keys which took care of the F11 and ALTF11. The problem I dont have access now to anything either. I tried your attached database to lock and unlock and nothing happened. Am I missing something. I also disabled the Toolbars so users dont have access to any toolbars other than the form. Now Unchecking the Special Keys in StartUp disabled as I said F11 and Alt F11 to everyone including myself. Please let me know how can I have access to special keys but not the users. Also what is the purpose of the attached database you sent.

    Boblarson,

    I looked into the Splitdatabase and the problem the users have to go into the Safety folder on the intranet and use the form on the Database since not all users have their own computers. I cant put a copy on the frontend on each computer because I wouldnt know which computer the user will be at at one point in time.

    Its all locked and secured with the exception of F11 and Alt+F11. I can ofcouse disable all special keys at Start Up but I will lose access myself too. The Alt+F11 I was able to put a password to view or alter any of the modules, etc. The F11 on the other hand I cant stop anyone from using it
    ramez75, January 12th, 2009 09:48 AM
    Reply With Quote Reply With Quote
  5. #5
    AOG123
    AOG123 is offline
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    correct, you will lose access to F11 and Alt+F11 aswell,. but you can hold the shift on db open,. ('if you need to access the design')

    This is the purpose of the attached db, it disables/enables the shift key on open, to stop users exploiting this special key.

    It's a shame you can't split the db, to fe/be, boblarson is very correct in his comments.
    AOG123, January 12th, 2009 10:16 AM
    If i helped you, make me famous by clicking the
    Reply With Quote Reply With Quote
  6. #6
    ramez75
    ramez75 is offline
    Barn Newbie ramez75 is an unknown quantity at this point ramez75's Avatar
    Join Date
    Nov 2008
    Posts
    27
    Rep Power
    4

    Even if I split the database to BE/FE, the users will not be able to modify the tables, but they will have acces to macros and the Modules as they are saved in the FE not the BE unless I am missing something
    ramez75, January 12th, 2009 11:09 AM
    Reply With Quote Reply With Quote
  7. #7
    ramez75
    ramez75 is offline
    Barn Newbie ramez75 is an unknown quantity at this point ramez75's Avatar
    Join Date
    Nov 2008
    Posts
    27
    Rep Power
    4

    Boblarson,

    I did the Split like you suggested. I have a folder on the network where I have the BE with the queries, macros. Also I have the frontend with hidden tables. I also created the .mde and disabled the Special Keys at startup. Everything is great so far. I have 2 questions. Why do I need to send the frontend to the users workstations/PC. I cant create a shortcut of the FE.mde file and email it to all the users to place on their desktop. Or just send copies of the FE.mde to all users. If I use the first idea each time I update the FE.mdb I will create a new FE.mde and with them having shortcuts it will be alright and no need to update them at all.

    The other question i have is i read the article you sent me and downloaded Tony's free updater, I still didnt get how exactly it work. I mean I made it work but it seems I have one more step extra. since I am running the GetStarted.ini in the Netwrok directory where I have the FE.mdb & BE.mdb and the file that gets created, I make a short cut of it and send it to all the USERS workstations.

    Please let me know if I am missing something or my approach is wrong. Unless they are suppose to have some kind of a file with the FE.mde that will automatically checks for updates done to the FE.mdb and/or BE.mdb, either way it seems I am missing the main point

    Thanks in advance
    ramez75, January 12th, 2009 08:06 PM
    Reply With Quote Reply With Quote
  8. #8
    boblarson
    boblarson is offline
    Barn Regular boblarson will become famous soon enough boblarson's Avatar
    Join Date
    Jul 2008
    Location
    Portland, Oregon
    Posts
    66
    Blog Entries
    1
    Real Name
    Bob
    Rep Power
    4

    The backend should have the tables, the frontend should have all other items (forms, reports, macros, queries, code).

    As for auto updating, I have my own frontend auto updater (available here on my website: BTAB Development - Access Tools ) which might be easier for you.
    boblarson, January 12th, 2009 09:52 PM
    Bob Larson
    Access MVP (2008-2009, 2009-2010, 2011-2012)

    Free samples and tutorials: http://www.btabdevelopment.com

    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Similar Threads

  1. Hashing (Encryption) Password & Other Sensitive Information
    By BLaaaaaaaaaarche in forum ASP Code Samples
    Replies: 5
    Last Post: February 23rd, 2009, 10:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


SEO by vBSEO