Results 1 to 7 of 7
  1. #1
    thecsmith70 is offline Novice
    Windows 2K Access 2007
    Join Date
    Sep 2014
    Posts
    15

    Accessing MDB on network drive

    Hi,



    I have about 15 users on a ACCDE file I distributed to my team. The ACCDE has a link to the back end file located somewhere on the network drive.

    I have instructed my users to shut down their ACCDE file on Friday afternoons so I can perform a back up routine. Not everyone follows my instruction, I guess. How do I find out who has the Access file open? Is there a way to identify a user?

    Does anyone have a better solution for a dilemma I'm having?

    Thanks.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,760
    I have a table of Users. Has record for each user with their network username. I have code that identifies the user and the computer when they open the db. Code inserts computer ID into their User record. The computer ID is removed when they close db (actually, when the main menu form closes because it only closes when the db is closed). I can see in the table who on what computer has the db open.

    Review https://www.accessforums.net/access/...gin-23585.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    thecsmith70 is offline Novice
    Windows 2K Access 2007
    Join Date
    Sep 2014
    Posts
    15
    Thanks June. I glanced at the link you just gave me to review. I will need to take a look at it again. It looks complicated than I thought.

    In your table, when you list the network username and if someone is not listed, they cant open the database? Is that how it works? If so, that's definitely what I need.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,760
    Post 4 of that link describes how I handle new users. You could modify to reject the user if they aren't already in the table.

    Be aware that holding down shift key while opening db will bypass database option settings and this code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    thecsmith70 is offline Novice
    Windows 2K Access 2007
    Join Date
    Sep 2014
    Posts
    15
    Okay, I'm going to try and tackle this on Monday. Since I am a beginner, I probably will have more questions. Would it be okay if I inbox you?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,760
    Continue discussion in thread. I will see it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    thecsmith70 is offline Novice
    Windows 2K Access 2007
    Join Date
    Sep 2014
    Posts
    15
    I took the courage to take a look at it again, but could not come to sense. I have zero experience of using VBA. I want to learn how to:

    1. create a list of users (by machine name) who can use my front-end (MS Access) dbs?

    2. tell me who is currently using the dbs (so I can ask them to log off when I need to go in the back-end for maintenance.

    I am going to try this thread: https://www.accessforums.net/access/...ase-20653.html.


    Thanks.

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

Similar Threads

  1. Max users on a network drive
    By data808 in forum Access
    Replies: 2
    Last Post: 10-23-2014, 02:12 AM
  2. Accessing db on network
    By JeroenMioch in forum Access
    Replies: 3
    Last Post: 10-08-2014, 06:43 AM
  3. Replies: 1
    Last Post: 03-13-2014, 10:11 AM
  4. Replies: 3
    Last Post: 05-21-2013, 05:48 AM
  5. Error message when mapping network drive
    By dwcolt in forum Programming
    Replies: 5
    Last Post: 05-11-2011, 08:56 AM

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 - Senior Forums