We help IT Professionals succeed at work.
Get Started

Access to SQL Server Link Tables list showing up as syncobj

1,017 Views
Last Modified: 2012-05-12
I am trying to setup a linked tables to SQL Server 2000 database where the user only has read permission.

I created an SQL user and added them to the db_datareader role, then I created an ODBC connection in my Data Sources.  When I go to add the tables in Access through External Data -> ODBC Database, ->"Link to the data source by creating a linked table" the list of tables shows up as dbo.syncobj_0x3030314244344641 (as an example).

If I change the user's permissions from the db_datareader role to the db_owner role, all the table names display correctly.  I ran SQL profiler to see what was being run and I found that master.dbo.sp_tables was being executed so I granted execute permissions to that stored procedure for that user, but that did not solve my problem.



 Linked Tables view of syncobj
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE