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

[Lyubomyr]

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

 

[RoyVidar]

Sure it's possible - search this forum with keywords Access query - and I'm sure you'll get hits.

Here are some thread796-1092119, thread796-1040473...

Also check out this Working with MS Access Stored Procedures in VB.NET. Part 1

Roy-Vidar

 

[RiverGuy]

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.

 

[Lyubomyr]

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