?
Solved

Workbook with ODBC query shared by multiple users

Posted on 2012-09-21
4
Medium Priority
?
521 Views
Last Modified: 2012-10-09
Greetings,

I created an Excel 2010 workbook that contains a query to an external data source (a specific query in an Access database). I stored the workbook and the Access db on a network location that's accessible by all users who will use this workbook.

I can flawlessly use this from the machine I originally created the whole thing on but when I open the workbook and try to refresh the query on another user's machine, I get the error "Too few parameters expected".  The workbook does contain 2 cells that are used as parameters (a start date and end date) for the query and there doesn't seem to be anything wrong the entries there.

The user has permission to access the network location, the ODBC connection is set up correctly on the user's computer.  What am I missing?

More generally:  I need for multiple users to be able to successfully run the query without creating individual spreadsheets for each of them.  Suggestions please?

Many thanks!
0
Comment
Question by:monkeybiz12345
  • 3
4 Comments
 
LVL 14

Expert Comment

by:JP
ID: 38451548
To me it sounds like it cannot find the ODBC connection because it is not on the other computers. I know you can query without creating ODBC connections on the PC but the code has to be written differently.
0
 

Accepted Solution

by:
monkeybiz12345 earned 0 total points
ID: 38464918
Thanks for trying, Peetjh.  However, the ODBC data source is set up correctly and working properly on all the computers that need to access this spreadsheet.

For now, I've decided to create multiple local copies for each user that needs access. I just wanted to avoid doing that so I don't have to maintain it in multiple places.
0
 

Author Comment

by:monkeybiz12345
ID: 38465534
Hmm... when I requested attention for this question, modus_operandi suggested that Peetjh might've been referring to a DSN that was not present on all machines.  Could be...  I'll check that out next time I think of it and post back here if that leads to more information about the problem.
0
 

Author Closing Comment

by:monkeybiz12345
ID: 38476702
Creating a separate copy of the spreadsheet on each user's machine was the solution I was trying to avoid but that's how I ended up working around it.
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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

840 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