VB.Net

I am using VB.NET (2003) and Access (2003). I have a complex query that works perfectly if I run it within Access. But if I move it into my VB project, it fails to return the last 10 or so records I added. I added a condition to the query that cut the expected results in half, but the missing records are still missing. I have used this SQL code in my VB app for many months without a problem. I have gone so far as to copy the SQL query from the debugger window while running my app and pasting it into Access. The app still misses records; Access query works perfectly. Any thoughts. Thank you.
askanyquestions123Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
administradoresConnect With a Mentor Commented:
Make sure you are working with the same database in access and VB, once it happen to me that the db file wasn't the same and went crazy.

Or if you can paste the connection string.
0
All Courses

From novice to tech pro — start learning today.