--------------------------In the table ----------------------

SQL> desc table1
Name Null? Type
------------------------------- -------- ----
ID NUMBER
PID NUMBER
NAME VARCHAR2(20)

-------------------the records are----------------------

SQL> select * from table1
2 /

ID PID NAME
--------- --------- --------------------
1 1 sdfdsa
2 1 sdfsd
3 1 sdfaasd
4 2 asdasd
5 2 sdafsd
6 1 asdfasd
7 3 sadfasd
8 4 dsdaf
9 8 dfsgsdf
10 8 dsfsd

---------------------------------------------------------------

I want to apply the following query in Microsoft access using jet for the same as above access table
Please help me out.
-----------------------------------------------------------------------
select id from table1 connect by prior id=pid start with id =4
-----------------------------------------------------------------------