Storing Queries From Visual Basic to MS ACCESS

[vinitsankhe]

Hi,

I m a beginner to VB. I m usin Visual Basic 6.0 envmnt and trying to store SQL Access Queries & not usin VBA atal.

I used Access.Application CONNECTION (ACCESS 9.0 ActiveX Object ), but not getting what function to use for storing an SQL Query in the MDB file under Query Object Section with some name. My program will call the stored Query when reqd. I also want to delete it as soon as its used. I don't want to use any other DB Connections such as ADO/DAO/ODBC etc.

Is it possible to store it in the ACCESS file? Plz suggest sum steps.

Thanks,

V.S.

[Twodogs]

Use ADOX instead - search MSDN for ADOX and you should find what you're after.