Please help me to solve this small(quite big actually) but hard problem.
I have an access database in computer A. I also have an application in computer B that need database in computer A. So I make access database in computer B and make link table to database in computer A.
When I use the application to modify the data, come up an error "Cannot update using the query". That's very strange, because if I put the application in computer A, it works.
Please help. Thank you.