Results 1 to 2 of 2
  1. #1
    rjbautista20 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    23

    Change ODBC of Pivot Table from DSN to DSN-less going to SQL Server

    Hi Guys,



    need your help again.

    I have lot of lot of Pivot table connected via ODBC going to MS Access. and just this month I already migrated all my tables to SQL server. I created a DSN connected to SQL and change all my pivot to the new connection.

    my problem now is if some user will be goin to refresh the pivot, pivot will get errors because i need to declare also the DSN in his/her PC..


    is it possible to change my Current DSN Connection to DSN-less Connection?

    Hope you guys can help me again.

    Thanks.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    not if you're going to link an item no, it has to have a DSN.

    You can fix the error you're getting by creating a new ODBC connection and re-linking all your objects or modifying your current ODBC connection to point to the new server.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change Pivot Data Source from MS Access to SQL Server
    By rjbautista20 in forum SQL Server
    Replies: 3
    Last Post: 06-24-2013, 11:36 PM
  2. Access security ODBC to SQL Server
    By Mark@CHP in forum Security
    Replies: 3
    Last Post: 03-27-2012, 08:31 AM
  3. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  4. Replies: 8
    Last Post: 01-30-2012, 02:13 AM
  5. Replies: 5
    Last Post: 10-25-2011, 08:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums