ADP connection to SQL 2005 Standard SP2

  • Thread starter Thread starter Urya
  • Start date Start date
U

Urya

Hi,

I have Access 2007 on Vista and SQL 2005 SP2 on Windows 2003 Enterprise.
I created ADP from Access 2007, created the connection and Test Connection
was successful.
However, when the database is open up in ADP, I cannot browse any Table or
View in DB within SQL 2005.
The names of Tables don't even show up.
Please help me get an access to the database objects.

Thanks.
 
It's not sufficient to connect to the server, you must also specify the
database that you want to connect to (point #3 on the Data Link Properties
dialog window).
 
Sylvain,

Thanks for your reply.
Sorry about the confusion but I did select let's say "Master" or "model" DB
to connect. Test connection was successful and ADP opens up with a title
including the DB name. However, nothing on the left hand list such as "Table"
gets populated.
I never had problem with SQL 2000 so I'm little bit puzzled.

Thanks.
 
Normal, usually, there are only system tables in either Master or Model.
Create or choose a user database and you should be OK.
 
Oh, that's why!
I didn't know that Access would not see system tables...
Yes, I can see other Databases with user tables.
Thank you for your help!
 
Back
Top