I'm not exactly a guru but it sounds like the login info specified in your
ODBC connection being used in CF studio does not have the proper permissons
set up to see those particar tables. You might try going into sql enterprise
manager and double clicking on the table you want to see. There you will see
a permisissions button on the upper right hand cornor of the pop up
properties box. Click on it and you will be able to specify permissions for
that table to the user specified in your ODBC connection.
I'm could be wrong. I'm just shootin from the hip here.
Lee
----- Original Message -----
From: Francis NART <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 01, 2000 9:54 AM
Subject: SQL7 + CF studio pb !
> I'm brand new to SQL server 7 and I have a little pb.
> Each time I want to access my tables through CF studio in the database
Tab,
> I only get the system tables and not the one I created manually.
>
> I get an error when I try to access those newly created tables.
> Using the SQL server query analyser I've got no problem accessing thoses
> tables...
>
> Could a "SQL server Guru" help me on this ?
>
> Thanks
>
> Francis.
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
