Results 1 to 10 of 10
  1. #1
    JimmieC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    6

    Cannot Access Backend Data

    I have two laptop computers. Both have Access 2010 installed. Both computers are on the same Workgroup and each computer can access files on the other. Computers are connected with wireless connection. Computer 1 holds the backend data while computer 2 is used for data entry and connects to backend on computer 1.Both computers are used for data entry, and as I said, data is stored on computer 1 only.

    Here's the problem. If I enter data on computers 1 and then open computer 2 I cannot access the data unless computer 1 exits and then reopens. If computer 1 does not exit and reopen I cannot access the data from computer 2. In addition, if I enter data in Computer 2 and save it then computer 1 can see the data and all is well. So, for everything to work I have to start the data entry in computer 2. If I start data entry with computer 1 then I have to go through the save and shutdown process.



    I have tried requery and refresh, refreshpage, refreshrecord, etc, but with no success.

    Any help is appreciated.

    Jim

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    is Computer 1 also a split database?...in computer 1 you must use just an FE like computer 2 and link to the tables in the BE file as if they were in a neutral location.... you can't work directly in the file holding the tables.

  3. #3
    JimmieC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    6
    Yes, computer 1 is a split database, it uses an FE just like computer 2. The FE in each computer is linked to the tables in computer 1. I don't know if I made this clear but the problem occurs only when I enter a new record in computer 1. Both computers enter data for todays date only. Each date is a new record. When the computers are first powered up and a date is entered into computer 1, computer 2 cannot see it. But if after entering the new date, computer 1 closes the database and then reopens, then computer 2 can see the new date. And, as I previously said, if I first enter the new date in computer 2 then computer 1 sees it and all is well.

    Jim

    Jim

  4. #4
    JimmieC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    6
    Learning more about this problem. First, from Computer 2 I can refresh records if I use RefreshAll from Quick Access Toolbar but I cannot refresh or requery using Button on form. Normally I refresh using a Button or using the DoCmd.Refresh for a particular event. For some reason my buttons are not working from Computer 2. Macros work but simple DoCmd commands like "go to last record" are not working??? Computer 2 FE linked to BE on Computer 1.

    Jim

  5. #5
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Try changing the DoCmd.Refresh to DoCmd.ReQuery - Refresh just "re-draws" what's already on the screen, it doesn't go back and check to see if the data has changed.

    As for the other issues, it sounds like Access might not be opening the FE as a Trusted Document. I would make sure the (FE) database is in a Trusted Location and that you don't get any warnings when opening it.

    And thirdly, when a user opens a Recordset/Table/Query in a mode other than ReadOnly, Access locks the entire memory "page" that data is on. Depending on your data, it's possible for multiple Records to fit into a single page. If this is the case with your database, Access may be locking the data you're looking at on Computer 2 simply because a user on Computer 1 is looking at "nearby" data. This issue has caused all kinds of trouble where I work!

  6. #6
    JimmieC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    6
    Rawb,
    Thanks for the help. Things are getting worse, I can no longer enter data from Computer 2. Not sure what's going on.
    Jim

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Using Access over wireless is not a good idea.

    You should read http://www.kallal.ca//Wan/Wans.html
    (look for Why a does JET file share corrupt when the connection breaks?)

  8. #8
    JimmieC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    6
    Well, I fixed it! All along it was the Trust Center settings. Somehow my macros were turned off and that stopped all data entry.
    I enabled the macros and now my code works. I am now using Requery and it works so I'm able to enter data from either computer with no problems.

    Steve, thanks for the input. I've been using this setup for over a year and this is the first problem I've encountered. I don't know how the Trust Center settings were changed??

    Jim

  9. #9
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    If you have had an update to Windows, sometimes that will reset a lot of things in Windows you don't know about.

    Just remember, over wireless, it's not IF it will corrupt, it is WHEN it will corrupt (and it will).

    Remember the three rules of computing: 1)Back up, 2)Back up, 3)Back up

    Good luck.

  10. #10
    JimmieC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    6
    Thanks Steve,

    I just updated Windows and that's when my troubles started. Yes, I've read of data corruption with Access in wireless networks and plan on going to a wired network in the future. Good advice about the backups, presently we back up to local storage and also to Tresorit.

    Jim

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

Similar Threads

  1. Replies: 3
    Last Post: 01-02-2014, 08:11 AM
  2. Protecting backend table data
    By uncletreetrunk in forum Security
    Replies: 1
    Last Post: 07-30-2012, 09:51 AM
  3. Can't delete data from Backend
    By srcacuser in forum Access
    Replies: 2
    Last Post: 03-21-2012, 01:22 PM
  4. Replies: 1
    Last Post: 01-12-2012, 09:43 AM
  5. Data transfer to restructured backend database
    By RANCHLAW56 in forum Access
    Replies: 1
    Last Post: 09-06-2011, 01:47 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