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