Results 1 to 6 of 6
  1. #1
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95

    Working locally and storing data part of database on network drive

    Hello everybody.



    I have 4 laptops working on a same Access database (FORMS.accdb), all linked to one data database containing just tables (DATA.accdb).

    Question is:
    What can I do to minimize data loss in case of power supply failure (which occurs at least once a day) when while working on one of those 4 laptops I lose connection with group drive (G:\).
    How can I on a best way continue working on one of those laptops and make Access reconnects to DATA.accdb and fill it with new records when power supply comes back?


    Click image for larger version. 

Name:	Working locally and storing data part of database on network drive.jpg 
Views:	12 
Size:	119.8 KB 
ID:	23878

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if it happens once a day (too much) then buy a UPS.

  3. #3
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95


    Problem is, I am not allowed to do so..

    What can I do generally to minimize chances of loosing data?

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    These are NOT wireless connections, correct? Corruption problems are a recognized problem with wireless network. Slightest hiccup could result in corruption.
    UPS or more stable power is first step in any answer.

    I have seen articles/posts saying moving to SQL Server (Express) will resolve wireless-based connection issues.
    Last edited by orange; 02-27-2016 at 09:39 AM. Reason: spelling

  5. #5
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    It's a LAN network with laptops on Company's domain...

    I have days when power supply is not an issue but LAN network which breaks in the middle of record input in the database.. I would like someone to tell me is there a way to create a buffer which is filled automatically upon losing power supply which is emptied towards my database when the network is back on..

    To be honest, I don't know how to express myself properly but I would feel stupid if after a year of database usage I would discover a simple and effective method of data loss prevention..

    Thanks

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I do not have direct experience with the situation you are describing. From forums I have seen that an effective cure in a "database-sense" is to use SQL server (even Express which is free). By its design it is more tolerant of "connectivity/network issues".

    It still seems that a UPS would be a first logical move.

    I get the feeling that your company's approach to database and information management is to get something working, at least for part of the time.

    Regarding
    ....LAN network which breaks in the middle of record input in the database.
    , I am sure that experienced developers/users will tell you that is a major cause for Access database corruption.

    See this article from Allen Browne.

    Good luck.

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

Similar Threads

  1. Problem Saving PDF to Network Drive
    By David Ford in forum Reports
    Replies: 1
    Last Post: 02-05-2016, 01:16 PM
  2. Accessing MDB on network drive
    By thecsmith70 in forum Access
    Replies: 6
    Last Post: 02-19-2015, 03:21 PM
  3. Max users on a network drive
    By data808 in forum Access
    Replies: 2
    Last Post: 10-23-2014, 02:12 AM
  4. Replies: 1
    Last Post: 03-13-2014, 10:11 AM
  5. Replies: 0
    Last Post: 07-14-2010, 04:01 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