Solved

Linking a SQL server table to access

Posted on 2011-02-11
2
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

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

Author Comment

by:havette
ID: 34872981
Thanks, it was indeed a problem with permissions
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
configure service broker on all databases 2 94
How to simplify my SQL statement? 14 55
Help with simplifying SQL 6 54
Find unused columns in a table 12 75
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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