Missing data from linked table

[tprice5]

I have all my data sitting on a server in SQL. Within Access, I have linked tables pointing at SQL tables. I display the data on an Access form. Somewhere in their it is dropped a few records. This system is used for in and out processing and occasionally misses a few individuals. Could this have anything to do with the method in opening the table, ie dbopenTable vs dbOpenSnapshot. I am just out of ideas and need this fixed.



Thanks for the help!

[tanvi]

To manage linked table issue, you should relink it again. Check this article, it will guide you: How to manage your linked tables:
http://data-base-recovery.blogspot.i...tables-in.html