Excel Connection to Access Query (1 Viewer)

Chief

Registered User.
Local time
Yesterday, 18:19
Joined
Feb 22, 2012
Messages
27
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 :banghead: 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.
 

Attachments

  • ConnectionError01.jpg
    ConnectionError01.jpg
    34.4 KB · Views: 66
  • ConnectionError02.jpg
    ConnectionError02.jpg
    33 KB · Views: 71
  • ConnectionError03.jpg
    ConnectionError03.jpg
    30.2 KB · Views: 64
  • ConnectionType.jpg
    ConnectionType.jpg
    58.4 KB · Views: 75
  • ConnectionType02.jpg
    ConnectionType02.jpg
    67.2 KB · Views: 66

Chief

Registered User.
Local time
Yesterday, 18:19
Joined
Feb 22, 2012
Messages
27
Just an Update...
I also tried to put the query into the back end section of the database and change the connection to this location.
Unfortunately same error.
 

paulcherianc

Registered User.
Local time
Yesterday, 18:19
Joined
Aug 15, 2013
Messages
86
Try Connection using pivot table external connection :
See the pic
 

Attachments

  • Capture.JPG
    Capture.JPG
    28.7 KB · Views: 49

Chief

Registered User.
Local time
Yesterday, 18:19
Joined
Feb 22, 2012
Messages
27
Hello,
Thank you for the suggestion, but still no luck.
 

Users who are viewing this thread

Top Bottom