Hi,
We have a wired problem here. There are two tables A and B, the primary key (see CID) of table A is the foreign key of table B. Table A is in SQL 2000, table B is in Access 97. When two table join in Access 97, the records will not be returned in the result if CID > 999. We didn't have the problem before, it just happened. Does anyone have any clue about this problem? Thank you in advance!
We have a wired problem here. There are two tables A and B, the primary key (see CID) of table A is the foreign key of table B. Table A is in SQL 2000, table B is in Access 97. When two table join in Access 97, the records will not be returned in the result if CID > 999. We didn't have the problem before, it just happened. Does anyone have any clue about this problem? Thank you in advance!