I have an application that links to a dbf file in Act2000 (CRM). I used the "attach sql table" option as I didnt want to link directly to it as the tables would be edited outside Alpha5 and I didnt think that any indexes created in Alpha to link the tables would be kept upto date and synchronized becuase of this (would alpha synch the tables automatically?).

This setup works fine untill I tried the same application on an XP Client, when I pop the lookup field I get the following message:
Cannot create lookup
Lookup definition, incomplete or invalid
IM002 data source name not found and no default driver specified

If I have to setup a system DSN on each client I will, but this worked fine on 98 and 2000 PC's, what's happend with XP?

Any help welcomed.