Results 1 to 10 of 10
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: advice needed making a user table & networking.

    Hi guys,

    I need some step by step guidance please. I have a database that i want to put on the shared drive at work so that around 20-30 users have access to it.

    I want the peopel to use the system but dont want them to mess around with any design or mess around with any of the tables. What would be the best way of doing this?

    also

    I have created a user table and want it to collect the login user ID of the person who enters records on the database. However i want to add more information later on in the user table. Like (full name etc)...


    Please can someone help me and give me some guidance on how to achieve this....

    Thanks


    Aboo

  2. #2
    Join Date
    Apr 2004
    Location
    Kingsland, Georgia
    Posts
    231
    Aboo,
    Look into using the Jet security. Set up a workgroup, set up user groups, assign permissions to the groups, set up user accounts, assign users to groups, etc. I have several dbs here at work (up to 80 users) and have no problems with users going where they're not supposed to. Got the info a few years back from this link
    Jack MacDonald. Check out the "Security Paper" link.

  3. #3
    Join Date
    May 2006
    Posts
    178
    jmahaffie,

    Thanks for your reply... seems abit too deep for my understanding...lol

    I have no admin rights to the network all I can do is put it on a shared drive.

    I wanted to know how i can log the username that logs onto the network and put it in a table.

    Any ideas?


    Aboo

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If you don't want people messing with your tables, then the only real answer is to have your tables on something like SQL Server.

    There is a cool function in the code bank that gets the windows username. GetUser() is the function. You could easily write a log of who is opening forms and what not -- but what stops the user from tampering with the logs?!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    May 2006
    Posts
    178
    Hey Trekker,

    The company i work for will not let me let me install anything on the pc's other than what is already on them....i.e access...


    any ideas?


    Aboo

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by StarTrekker
    ....There is a cool function in the code bank that gets the windows username. GetUser() is the function. You could easily write a log of who is opening forms and what not -- but what stops the user from tampering with the logs?!
    or do a GOOGLE for dev Ashish API.

    you can also log which computer did the dirty deed. that makes it harder for the miscreants to claim someone stole their userid

    if your company is serious about its network security and its applications integrity then they should be receptive to doing the job properly. secuirity is not a last minute bolt on.. it needs to be integrated into the application at route and branch level.
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    some little tricks i do

    Hide the Table you don't want user to see but every thing still works

    put =1 in the properties menu bar of the forums this hides the FILE EDIT ... menu

    hide the database when it open and only show the menu form

    there is some code out on the web somewhere that will disable the shift open command.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by aboo
    The company i work for will not let me let me install anything on the pc's other than what is already on them....i.e access...
    The codebank GetUser() solution doesn't install anything, but you would need to add a library reference for Access.

    But agreed on the fact that security isn't a last minute thing; it needs to be built into the application -- easiest done during building.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    May 2006
    Posts
    178
    Hi,

    The company i work for has a very very hi level of security. however this little database will be used within my team as to cut out some of the repetition that is taking place with data.

    Myle- Can you expand abit more on your reply please so i can follow some of those tips.

    Trekker,

    What is the get user functtio and how do i add it to the library. also i am using access 2000 if that has any bearing on the function.


    I am open to more ideas.


    Thanks

    Aboo

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    look in the Access code bank on this fourm,
    or
    do a google search for DEV ASHISH API
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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