Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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.
0
askanyquestions123
Asked:
askanyquestions123
1 Solution
 
administradoresCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now