DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Threaded View

  1. #1
    Join Date
    Jul 2007
    Posts
    3

    Query works in Access, but not VB .NET

    Hello,

    I'm a relatively new programmer, and I'm attempting to duplicate an Access query in to VB .NET. I expected this to be a simple copy/paste from Access, but that has not been the case. When I attempt to run the following query from Access, I get a ton of records. From VB .NET in a AccessDataSource control, I get nothing. Here's the query:

    <query removed>

    And here's the code (which has worked fine with other queries):

    <query removed>

    Any ideas would be greatly appreciated! I've burned 99% of my brain on this today. Thanks!
    Last edited by Brad Jones; 10-02-2012 at 10:35 AM.

Similar Threads

  1. Replies: 0
    Last Post: 01-07-2003, 02:20 PM
  2. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  3. Coding Access in VB
    By Scott in forum VB Classic
    Replies: 1
    Last Post: 05-12-2001, 04:17 PM
  4. Russell Jones
    By Bill Seddon in forum .NET
    Replies: 85
    Last Post: 02-01-2001, 02:49 AM
  5. Replies: 3
    Last Post: 05-12-2000, 04:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links