Cannot see SQLServer table when trying to link in Access 2000

Guest_imported · Nov 21, 2001

I am using SQL Server 2000, Ms Access 2000 under Win2k.
I created a database in SQL Server with one table.
I try to link the table in my access application but my table is not there. Instead there are system tables listed.

Looks like I'm making the connection to the SQL DB ok but my table is missing. Its midnight... I need help!

tomschafer · Dec 10, 2001

Check the default DB in your DSN.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Cannot see SQLServer table when trying to link in Access 2000

Guest_imported

New member

tomschafer

Technical User

Similar threads

Part and Inventory Search

Sponsor