Query in code is not pulling same info as same query in access

Question

I'm experiencing something strange. In my code, I'm running a simple "select * from product" and displaying results, but the results are short about 10 records (the newest records). The same query, when ran in access, pulls all records. The code is solid.

Any suggestions?

Suthish Nair · Answer

Ashley Your query resolved?

Sam Hobbs · Answer

Problems such as this is usually caused by assumptions that are not accurate. You are assuming that the data is coming from a certain database but it might be coming from a different database.

Suthish Nair · Answer

Suggest to check your connection string value refering.

Santhosh N · Answer

May be your front end application is restricting to bind only 10 records check that