R
Rob W
Greetings,
This question is a mixture of ms access and vb.net I guess.
My application utilises an access 07 database and a frequent sql query is to
count the rows where columnA = textbox.text or combobox.selectedvalue etc..,
This is hardcoded into each module, so took an opportunity to go about
reuses sql code.
I was looking into the OleDD commandtype and noticed it could run a stored
procedure, then found out MS access is not capable of creating a true stored
procedure but can create procedures via DDL.
I was messing around with access and noticed any query I created when
accessed via vb.net existed as a function.
What is the preferred method to reuse and execute SQL for a ms access 07
database in vb.net?
Can I access and run the database function from within vb.net?
Any help or advice would be appreciated
Thanks
Rob
This question is a mixture of ms access and vb.net I guess.
My application utilises an access 07 database and a frequent sql query is to
count the rows where columnA = textbox.text or combobox.selectedvalue etc..,
This is hardcoded into each module, so took an opportunity to go about
reuses sql code.
I was looking into the OleDD commandtype and noticed it could run a stored
procedure, then found out MS access is not capable of creating a true stored
procedure but can create procedures via DDL.
I was messing around with access and noticed any query I created when
accessed via vb.net existed as a function.
What is the preferred method to reuse and execute SQL for a ms access 07
database in vb.net?
Can I access and run the database function from within vb.net?
Any help or advice would be appreciated
Thanks
Rob