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!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot see tables when linking to SQL backend

Status
Not open for further replies.

AlbertAguirre

Programmer
Joined
Nov 21, 2001
Messages
273
Location
US
I am learning SQL server and I created a database with one table in order to link it into Ms Access 2000.
I created the DSN entry and attempted a link into access. The connection is established but I cant see the SQL server table in the list.
I can see system tables though.

Any ideas on whats wrong?

I'm desperate. Need help!!!
 
Does the login details for the SQL Server database you put in the DSN have adequate permissions to see the table?
<insert witticism here>
codestorm
 
Yes it does have those permissions.

I am new to SQL server but I thoroughly checked permissions and It looks good.

Why Cant I see my tables in ACESS? aRGH!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top