MS Access Stored Procedure and Sql from VB.NET -

i have built system in vb.net sql automatically generated , executed commandtype.text (default). in addition have created stored procedure in access database wish use "view".

i wish execute sql query utilizes stored procedure. kind of action possible?

i'm guessing isn't since commandtype can text, table, or storedprocedure.

    public function gettable(byval query string) dataset         dim connectionstring string = string.empty         connectionstring = "provider=microsoft.jet.oledb.4.0;data source=" + globalsettings.databases(globalsettings.databasetypes.submission) + ";"         dim connection oledbconnection = new oledbconnection(connectionstring)         dim command oledbcommand = new oledbcommand(query, connection)         dim dataadpter new oledbdataadapter(command)         dim dataset new dataset          try             connection.open()             dataadpter.fill(dataset)          catch loexception oledbexception             throw loexception                     if connection isnot nothing connection.close()         end try          return dataset     end function 

i don't want sql stored procedures. prefer execute commandtype.text.

any feedback on appreciated.