Linking SQL7 table to Access97

[Silas]

I would like to create a MSAccess97 front end for some SQL7 data.
I created an odbc source system dsn for the server holding the SQL7 data.
When I try to add a table to my Access97 database by linking it to a SQL7 table, the only choices presented me are tables in the default database for SQL7 on my server. How do I link to tables in another database on that server? Thanks.

[Carly]

This is from the top of my head.
When you are presented with the ODBC login screen click the options button which should allow you to change databases.
I sure that there is an entry which allows you set autologin or something like that, I believe in this case you need to create a new ODBC DSN, or pop up the linked manager a choose always ask.

Sorry for being a bit vague.


------------
Silas at 1/11/00 5:48:47 PM


I would like to create a MSAccess97 front end for some SQL7 data.
I created an odbc source system dsn for the server holding the SQL7 data.
When I try to add a table to my Access97 database by linking it to a SQL7 table, the only choices presented me are tables in the default database for SQL7 on my server. How do I link to tables in another database on that server? Thanks.