INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

OpenSchema() is missing some tables

OpenSchema() is missing some tables

(OP)
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.  

RE: OpenSchema() is missing some tables

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

e.g.

CODE

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"

RE: OpenSchema() is missing some tables

(OP)
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.  
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close