This may help: TableInfo() function

Ref: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access.queries&mid=53c7e3b9-af02-4e92-8413-034b1332cf8b
_________________________
Home page: http://www.kixhelp.com/hb/