Corrupt records in access tables

[hermajesty]

Hi
Have a problem (which is why im here!!!) Created an access database in 2003 to store patient referrals. Was working fine on my computer which si XP pro. Moved to their computers which are windows 2000 running office 2000. There are now errors appearing when users enter data. The auto number system gets messed up, and various fields have #error in them. When try to delete record says "The Search Key was not found in any record" Have seen post about errors when converting from 97 to XP, any help with this. Have tried moving info to new table still doesnt work.

Help please

 

[hymn]

In tools/options/advanced can change the default file format to 2000 on your machine and save the db then take it into work

Hope this helps
Hymn

 

[hermajesty]

Thanks - I will try that!

 

[hermajesty]

Checked the users computer references adn the ticked boxes are:
'Visual Basic for Applications'
'Microsoft Access 9.0 Object Library'
'OLE Automation'
'Microsoft Activex Data Objects2.1 Library'

Does this mean there is some sort of conflict. What would be the easiest way to solve this problem?

 

[hymn]

try adding the reference microsoft DAO 3.?

Hope this helps
Hymn

 

[hermajesty]

Do I add that to the companies Access?

 

[hymn]

set it up in yours, copy to the companies and see if it is there or there if it is missing

Hope this helps
Hymn

 

[hermajesty]

Sorry to be a pain - is it Microsoft DAO 3 - compatiblity ot Microsoft DAO 3 object library. Thank you for all your help - you have been great

 

[hymn]

laurakotas
Microsoft DAO 3.6 Object Library needs to ticked



Hope this helps
Hymn