Solved

Linking a SQL server table to access

Posted on 2011-02-11
2
224 Views
Last Modified: 2012-08-13
Hey everyone,

I'm trying to link a table from SQL server 2005 to access.
The problem is that when I want to "link ODBC database", and create a .dsn to access the database on the server, then when I'm ask to choose what I want to link, I don't have access to the tables, but only the views.

Does anyone have an idea why ?
Thanks in advance
0
Comment
Question by:havette
2 Comments
 
LVL 2

Accepted Solution

by:
itby earned 500 total points
Comment Utility
Does the user have access to all tabels in SQL?  
0
 

Author Comment

by:havette
Comment Utility
Thanks, it was indeed a problem with permissions
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now