[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • 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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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