ODBC Connection Error

[jclover]

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.

[cori25]

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

[cori25]

Also, make sure users have read write access to the database if they want to refresh it on there own.

[jclover]

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

[cori25]

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