Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

It it possible to use MS Access Queries in my VBA.NET app.

Status
Not open for further replies.

Lyubomyr

Programmer
Jul 23, 2005
21
UA
I got a problem. I have MS Access DB. I'd like to use (access) MS Access DB queries in VBA.net (not rewrite them in my code). I scaned whole ado.net but all i found was info about implementing sql procedures from MS SQL, Oracle and others. MS Access can't work with sql procedures.

Have any ideas.

It's real stupid if it is impossible 'course it is the question of security.

Please write at lease that it is impossible. I get really stuck.

Thank you
 
I've never heard of "VBA.Net". Access can use stored procedures in ANSI SQL mode I believe. ADO.Net can call some saved Access queries as stored procedures. You can also reference the Access object library.
 
Thank you!
My bad -- I used "PROCEDURE" but it should be "PROC". in MS Access queries. Probably it's a differnce of Truncated and ANSI SQL

Thank You it was really helpful
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top