Coding Access in VB

[Scott]

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

[Douglas J. Steele]

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