Hi Folks,

i can see there is a MsysObjects table in Access that is roughly the equivalent of sysObjects table in SQL Server. But what is the Access equivalent of sysColumns?

My task is to look through all my Access tables and find a column of a particular name and then return a result set listing the tables that contain that specified column - easy in SQL Server, not so in Access!!

Can anyone help?

Cheers,
Kyle Henly.
SQL DBA.