By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

ODBC Connection Error

P: 17
I have an excel spreadsheet that is linked to a query in an access database on a shared network drive. There is no security in the database, or the spreadsheet. As of this weekend, the other users of this query are no longer able to refresh the data from the Excel side (via existing macro, or simple refresh) without getting:

"[Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression"

However, when I open the document, it doesn't have this error, and allows me to update it.

What would cause other users/computers to face this error, but not me?

Thanks in advance.

Using Office Suite 2003.
Mar 11 '08 #1
Share this Question
Share on Google+
4 Replies


cori25
P: 83
Hello...

You can only refresh xls documents on the computer where the database it is pulling the data from is located.

Unless you move the database to a shared drive where all users attempting to refresh the xls have access. If you do this you will have to relink to the table or query where you are getting the data from so that it has the correct path.

I would recommend you leave the database on your c drive or wherever you may have it and have a module run everyday that will run the macro in excel to refresh the document and then send out an email to recipients daily with the updated report.

Hope this helps
Mar 11 '08 #2

cori25
P: 83
Also, make sure users have read write access to the database if they want to refresh it on there own.
Mar 11 '08 #3

P: 17
The database is already on a shared drive. The excel document is located on the shared drive as well, same directory as the database. Like I said, this all worked fine for the last 2 months, until Monday, then the error came up. Since the database is live, and updates are constantly made to it, it's important the users have the ability to refresh the file as necessary.

I've never had this issue before. Any change this might have something to do with Daylight Savings changes?

Hello...

You can only refresh xls documents on the computer where the database it is pulling the data from is located.

Unless you move the database to a shared drive where all users attempting to refresh the xls have access. If you do this you will have to relink to the table or query where you are getting the data from so that it has the correct path.

I would recommend you leave the database on your c drive or wherever you may have it and have a module run everyday that will run the macro in excel to refresh the document and then send out an email to recipients daily with the updated report.

Hope this helps
Mar 11 '08 #4

cori25
P: 83
I do not think that daylight savings would have any effect on this. Something has changed in either the database or the excel spreadsheet. My suggestion is to relink the excel spreadsheet to the query in access. Also, I am sure you are aware that if someone is in the query or tables connected to that query, the refresh will not complete.

Thanks
Mar 12 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.