tags:

views:

260

answers:

4
+1  Q: 

Hierachy recordset in ms access

How can I get hierachy recordset in ms access through select statement?

+1  A: 

DAO doesn't support Hierarchical recordsets. You may be able to use ADO in access, but I'm not certain.

theo  2008-09-18 03:34:43
You can use ADO in access by adding a reference to the ADO library through the visual basic for applications editor.
ranomore  2008-09-18 03:38:33
A: 

What kind of hierarchy? Parent-child or nested sets?

ranomore  2008-09-18 03:37:09
+1  A: 

ADO 2.0 support MSDataShape - an OLEDB provider.

Check out data shaping at http://microsoft.apress.com/asptodayarchive/72268/data-shaping-with-ado-part-1

Ash Kim  2008-09-18 03:39:04
A: 

This article on Managing Hierarchical Data in MySQL should also be suitable for Access.

You may also wish to read this article, it offers a different approach.

Remou  2008-09-18 08:01:07

related questions

Backup SQL Schema Only?
Sql to query a dbs scheme
Timer-based event triggers
Sql query, count and group by
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting
How do I use T-SQL Group By
What all do I need to escape when sending a (My)SQL query?
Split String in SQL
Datatable vs Dataset
ASP.NET MVC "CRUD" Database Sample
Convert HashBytes to VarChar
Best Book for a new Database Developer
What is the best way to avoid SQL injection attacks?
What language do you use for Postgresql triggers and stored procedures?
What is the best way to handle multiple permission types?
How do I index a database field
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Is there a version control system for database structure changes?
How to export data from SQL Server 2005 to MySQL
ASP.NET Site Maps
Decoding T-SQL CAST in C#/VB.net
Flat File Databases in PHP