------------------------- Mike wrote: ------------------------

Subject: Re: List of all tables in Access

From: "Mike" <mike.day@o...>

Date: Mon, 10 Dec 2001 09:31:26

X-Message-Number: 2



select * FROM mSysobjects

WHERE (((mSysobjects.Type)=1)) OR (((mSysobjects.Type)=4));



cheers



-------------------- And here's my reply: --------------------

Actually, I think to get the linked tables listed as well (which I believe Vinay

asked for originally) you need to use:



SELECT * FROM mSysObjects

WHERE (((mSysObjects.Type) = 1)) OR (((mSysObjects.Type) = 4)) OR

(((mSysObjects.Type = 6));



Chris Kryshtalowych

Systems Specialist

University Healthcare System

Augusta, Georgia