Hello
I can connect to an ACT 6.0 database via the following adodb connection string:
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\test;
However if I query all records, I don't get as many records returned as the ACT program shows:
Act shows I have 639 contacts in a database, but if I do "SELECT * FROM test.dbf", only 527 records get returned.
To top it all off, some of those 527 are records that have been deleted from Act!
Do you have any idea why this is, and what I could do to fix it?
I can connect to an ACT 6.0 database via the following adodb connection string:
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\test;
However if I query all records, I don't get as many records returned as the ACT program shows:
Act shows I have 639 contacts in a database, but if I do "SELECT * FROM test.dbf", only 527 records get returned.
To top it all off, some of those 527 are records that have been deleted from Act!
Do you have any idea why this is, and what I could do to fix it?