Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Can't see a particular table in a database
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 6th August 23:03
cqmman
External User
 
Posts: 1
Default Can't see a particular table in a database


Hello,

I am trying to get info from a SQL7 database via ODBC. I can connect and
view the vast majority of tables, but one particular table (ceninfo_data)
does not appear.

In SQL Enterprise manager, I have taken a look at the permissions on the
table and public can select from it.

What am I missing?

Cheers
CQMMAN
"See, free nations are peaceful nations. Free nations don't attack each
other. Free nations don't develop weapons of mass destruction." George W
Bush -Milwaukee, Wis., Oct. 3, 2003
  Reply With Quote


  sponsored links


2 6th August 23:03
cqmman
External User
 
Posts: 1
Default Can't see a particular table in a database


Doh!

Fixed it. I was replicating a database and had changed the permissions on
the original, but not on the replicated database.

Cheers
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666