?
Solved

VB.net List all query names in an Access database using Oledb Connection

Posted on 2014-08-11
2
Medium Priority
?
612 Views
Last Modified: 2014-08-11
Hi

I am connecting to an Access database using an Oledb connection
What VB.net code would I use to list all of the queries in the Access database?
0
Comment
Question by:Murray Brown
2 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 2000 total points
ID: 40252627
Assuming you have read access on the system tables you can use the following query:
SELECT [Name] FROM MSysObjects WHERE [Type] = 5

Open in new window

0
 

Author Closing Comment

by:Murray Brown
ID: 40254403
Thanks very much
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question