J
Jim Heavey
Hello, I have a C# application which is currently accessing a SQL database.
I am now attempting to plug in an access database and get the application
to work with MS Access. This may sound strange, but my goal is to write an
application with is DB nutral....
It has been quite a while since I have done anything in access and I have a
couple of question about how to write "pre-established" queries which take
parameters...
When I build the query in Access, how do I identify a parameter value is
required and where it is required? If I had a query like the following,
how would I identify the paramters ( I put ?? where I want to pass the
parameter from a C# program).
Select UserName, UserPassword
where UserName = ??
Does Access support returning multiple answer sets like SQL? I think the
answer to this is no...that this is just a SQL thing.
Does Access have a "@RETURN_CODE"? How do I check the success of an Access
query?
Thanks in advance for your assistance!!!!!!!!
I am now attempting to plug in an access database and get the application
to work with MS Access. This may sound strange, but my goal is to write an
application with is DB nutral....
It has been quite a while since I have done anything in access and I have a
couple of question about how to write "pre-established" queries which take
parameters...
When I build the query in Access, how do I identify a parameter value is
required and where it is required? If I had a query like the following,
how would I identify the paramters ( I put ?? where I want to pass the
parameter from a C# program).
Select UserName, UserPassword
where UserName = ??
Does Access support returning multiple answer sets like SQL? I think the
answer to this is no...that this is just a SQL thing.
Does Access have a "@RETURN_CODE"? How do I check the success of an Access
query?
Thanks in advance for your assistance!!!!!!!!