MS Access: Queries & Reports

B

bornbroke

Member
Joined
May 11, 2005
Messages
6
Hi,

When the user opens a MS Access database, I would like to list the Queries & Reports listed in that .mdb file.

How would I be able to do this in .NET? either using ADO, DAO or ADO.NET.

Also, when the user clicks on a specific Queries or Reports, how can I start Access up from .NET?

thanks
 
Unless Ive missed something, .NET doesnt know anything about the non-data portions of Access databases. Youd probably have to use an Access object in your application to get to them.
 
is there a way to open a existing Query in the .mdb file?
for example, if you know the Table name you can use a sql statement; Select * from [tablename] to open the table, what about a Query?

I would like to know how I can display the existing Query in a datagrid. thanks.
 
bornbroke said:
is there a way to open a existing Query in the .mdb file?
for example, if you know the Table name you can use a sql statement; Select * from [tablename] to open the table, what about a Query?

I would like to know how I can display the existing Query in a datagrid. thanks.
Click to expand...
Hi there!
A query works just as a table outside of Access. You get the query data just as you get the table data "Select * from [queryname]...."

HTH
/Kejpa
 
kejpa said:
Hi there!
A query works just as a table outside of Access. You get the query data just as you get the table data "Select * from [queryname]...."

HTH
/Kejpa
Click to expand...


Ive already had tried that before posting the previous post, and as usual I had a minor syntax error!!!

thanks for making me look into it again without any doubt!!
 
Back
Top