Cannot Access Backend Data

[JimmieC]

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

[NTC]

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.

[JimmieC]

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

[JimmieC]

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

[Rawb]

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!

[JimmieC]

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

[ssanfu]

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?)

[JimmieC]

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

[ssanfu]

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.

[JimmieC]

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