Coding Access in VB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Coding Access in VB

  1. #1
    Scott Guest

    Coding Access in VB


    Hello.....

    It has been a while since I have used VB and Access and I am trying to remember
    what's the best way to interface with Access from VB. Specifically, writting
    nested SQL code within your VB program or calling a stored query def that
    is in Access from the VB?

    Nested SQL code in a VB app seems to be an awful way to go for maintenence
    reasons, but what is the recommened or most common way? I wish I was just
    using SQL Server instead of Access because using stored procedures is the
    answer there.

    Thanks!

    Scott

  2. #2
    Douglas J. Steele Guest

    Re: Coding Access in VB

    Nothing wrong with calling a stored querydef. In fact, it should be
    marginally more efficient.

    --

    Doug Steele, Microsoft Access MVP
    Beer, Wine and Database Programming. What could be better?
    Visit "Doug Steele's Beer and Programming Emporium"
    http://I.Am/DougSteele/


    "Scott" <scottysavage@yahoo.com> wrote in message
    news:3afc0b28$1@news.devx.com...
    >
    > Hello.....
    >
    > It has been a while since I have used VB and Access and I am trying to

    remember
    > what's the best way to interface with Access from VB. Specifically,

    writting
    > nested SQL code within your VB program or calling a stored query def that
    > is in Access from the VB?
    >
    > Nested SQL code in a VB app seems to be an awful way to go for maintenence
    > reasons, but what is the recommened or most common way? I wish I was just
    > using SQL Server instead of Access because using stored procedures is the
    > answer there.
    >
    > Thanks!
    >
    > Scott




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


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center