OpenSchema() is missing some tables

[WMXTeam]

We are using OpenSchema to return a list of tables in our SQL Server database. The two most recent tables (added in the past month) are not showing up in the list.

I have not used OpenSchema a lot and am not sure how it is finding the list of tables. Is there something wrong in our SQL database? And if so, how do I fix it.

Thanks for your help.

 

[hmckillop]

Can you show the statement you are using to return your schema

e.g.

Set rs = cn.OpenSchema(adSchemaTables, _
         Array(Empty, Empty, Empty, "Table")
      While Not rs.EOF
         Debug.Print rs!TABLE_NAME
         rs.MoveNext
      Wend

   End Sub

Have a look at this for more info on the Openschema, I think your issue is relating to the owner or schema where you created your table.

http://support.microsoft.com/kb/186246

"I'm living so far beyond my income that we may almost be said to be living apart

 

[WMXTeam]

You response prompted me to check the permissions, which appears to have fixed the problem. The two tables in question did not have the correct permission for the login I was using.

Thank you for the help.