Greetings all, One of my custo

[butler1850]

Greetings all,


One of my customers, has an Access database, created in Office 97, but converted to Office XP upon opening. (Prior to my arriving on the scene, by weeks/months)

They are currently trying to access this file from multiple PCs, and can do so, but when opened (even an exact copy, not shared, not over network), the 2nd PC does not open all the records that should be available. Why? How do I fix?

The functionality goes as such:

Open Access DB, select the form desired from the opening menu, and the listing of records down at the bottom shows a different number on the two systems. On the "production" system, it shows (when I was there last) something like 10500 records, but the machine which we are trying to gain access to this system on, shows 9400 records (or so).

Again, this happens regardless of whether it is a shared copy of the DB, or one that has been copied to the PC locally.

Any help would be appriciated, as I'm not an Access Guru, but rather a network guy that's trying to help my customer out.

Thanks
-Butler

 

[Shelbyville]

Not sure but first thing I'd try (if you haven't already) is to open the db on one pc - note the number of records. then MOVE (not coy) that copy of the db to another pc and check number of records. In that instance number of records should remain the same. (Suggesting this because it seems that either pcs are looking at different copies of the db (very bad idea) or some record locking is going on when the db is opened by the first pc.)

 

[Dreamboat]

Right-click all the fields in the form, and hit "Clear Filter/sort", just to be sure...

Anne Troy

http://www.VBAExpress.com