View Full Version : Query to get all my table names


n1gel
03-13-2007, 07:30 AM
Hi is there a query in access to return all of my table names.

to do what 'show tables' does in mysql

Frivolous Sam
03-13-2007, 08:01 AM
First link on Google for Access "show tables":
http://groups.google.com/group/microsoft.public.access.odbcclientsvr/browse_thread/thread/6efc8326cff8fd1e?hl=en&lr=&ie=UTF-8&frame=right&seekm=newsense-3011990833150001%40mam227-mac.odl.cornell.edu