MS Access: Queries & Reports

[bornbroke]

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

[Machaira]

Unless I've missed something, .NET doesn't know anything about the non-data portions of Access databases. You'd probably have to use an Access object in your application to get to them.

[bornbroke]

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.

[kejpa]

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.

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

[bornbroke]

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

 

 

I've 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!!