One terminal will not find all the Access records....

[judgehopkins]

I have several computers hooked up to a server where there resides a small Access database with about 8K records.

Every single one of the computers (seven) can read every record in the database, except for one.

I have upgraded to SP2, etc.

I am not sure where to look or even if I have told you enough info.

Thanks for any help.

“Some national parks have long waiting lists for camping reservations. When you have to wait a year to sleep next to a tree, something is wrong.” George Carlin

 

[JJOHNS]

I had a similar problem once. It turned out that a user had made a copy of my database and put it on their desktop, thinking they were creating a shortcut. To check, right click on the icon and make sure it is a shortcut and not a database.

 

[judgehopkins]

The user is clicking on the icon for the database on the server.

“Some national parks have long waiting lists for camping reservations. When you have to wait a year to sleep next to a tree, something is wrong.” George Carlin

 

[judgehopkins]

Problem solved:

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1111271&page=0&view=&sb=5&o=&fpart=2&vc=

“Some national parks have long waiting lists for camping reservations. When you have to wait a year to sleep next to a tree, something is wrong.” George Carlin