MS Access – Knickers In Twist

odbcerror

Once a year I see a problem with MS Access that I haven’t seen before.

This year it’s a problem with a query using tables linked to SQL Server. The query had been working for years but in my final testing before putting a change live it came up with an ODBC error not recognising a field in the SQL Server table.

Not finding any obvious problem I resorted to “Compact & Repair” as I suspected Access’s internal view of the query had been compromised in some way. I still got the error.

I managed to resolve it by opening the query in MS Access in the SQL View of the Query Design View. I then selected all the text, cut it and pasted it back in and saved the query. That seemed to force an update within Access and now the query works fine.

One for the scrapbook…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s