Results 1 to 9 of 9
  1. #1
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150

    sharing database over several users issue

    hi to all !

    after I have shared the database over the network to be shared to users through shared folder, how do we protect now the database file itself from being deleted since the database file is seen from the shared folder. The act of deleting the database file maybe just mere error or deliberate by any person who can access the shared folder.



    thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would not do it that way. I would split the Application to FrontEnd and BackEnd and give everyone their own copy of an MDE and put the BackEnd in a hidden directory of your system that is shared on the network but it will not be visible. Just name the folder what you like but end it with a "$" dollar sign.

  3. #3
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    yes RG. that is what I did. I made front and backend. I am sharing only the backend db on a shared folder.

    So I will just put a "$" dollar sign at the end of the name of my folder that I want to share to make it invisible in the network. Am I understanding it correctly?

  4. #4
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    ok. I have tried it myself RG. thank you very mucho. anyway do you have other trick other than putting the dollar sign?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Did the "$" work?

  6. #6
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    yes it did work RG. thank you very much. do you have other tricks?

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    None off the top of my head Marianne, sorry.

  8. #8
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    ok. thank you very much RG.

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Protecting against malicious or just ignorant users is a tough one. Data centers face the problem every day. Daily backups is their choice for a solution. I hope that helps.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Users on Database Simultaneously
    By rtemple in forum Access
    Replies: 2
    Last Post: 03-26-2009, 08:38 PM
  2. Database Design Issue
    By joekiteire in forum Database Design
    Replies: 6
    Last Post: 02-26-2009, 04:53 AM
  3. Track users use of Access database
    By booyeeka in forum Programming
    Replies: 1
    Last Post: 02-26-2009, 02:35 AM
  4. Replies: 0
    Last Post: 08-20-2008, 10:14 PM
  5. Multiple users accessing same database
    By 4ACE in forum Access
    Replies: 0
    Last Post: 02-28-2008, 03:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums