monkeybiz12345
asked on
Workbook with ODBC query shared by multiple users
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!
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!
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.