ADP connection to SQL 2005 Standard SP2

[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.

 

[Sylvain Lafontaine]

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

 

[Urya]

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.

 

[Sylvain Lafontaine]

Normal, usually, there are only system tables in either Master or Model.
Create or choose a user database and you should be OK.

 

[Urya]

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!