ADP connection to SQL 2005 Standard SP2

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

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

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

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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top