-
syscolumns equivalent in Access?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|