+ Reply to Thread
Results 1 to 1 of 1

Connection Issues, Excel To Access Query, Access 2010

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Connection Issues, Excel To Access Query, Access 2010

    Hello everyone,
    Using Excel and Access 2010..
    I have created a connection from Excel into and Access Query using the "from other sources\from Microsoft query" option. (Images ConnectionType and ConnectionType02)
    This then pulls in data from an access database query and Excel uses this data to formulate figures and produces charts accordingly.
    Works brilliantly on my laptop (Excel) into our work terminal server (Database)

    The Problem;
    When I place the excel worksheet onto the Terminal server for the company to use, I get Connection errors. (Images ConnectionError01,02,03).
    Majority of staff are using an RDP type set-up to connect into the terminal server. We have a multi site company.. lets not go there why its set up the way it is.
    The terminal server is using Excel 2010 and Access Runtime for the Access programs.
    I split the database into a front end and a back end and save the front end as a .accde file.
    Can I please get assistance to rectify this connection issue so I can appease the powers that be and they can use what I have created.

    I have created a macro command button on the spreadsheet which fills in some cells with dates and then calls the refresh all data function to activate the query connection.
    Appreciate the help.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  2. Excel 2010 userform to access and edit the data in MS ACCESS DB tables
    By anand_y59 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 07:46 AM
  3. Excel VBA makes ODBC connection to Access-How do you close the connection?
    By MrHockey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2010, 06:29 PM
  4. Microsoft Access Table Connection Issues
    By stoneferry in forum Excel General
    Replies: 0
    Last Post: 11-19-2007, 10:16 AM
  5. [SOLVED] Access query to excel and back to access updated??
    By jwr in forum Excel General
    Replies: 0
    Last Post: 03-19-2006, 08:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1