ODBC Error

[RayMilhon]

I have a Microsoft Access 2010 database developed for our Member Services Department. The Database works perfectly on my PC but on every other PC I get the following Error: ODBC-Call failed. [Microsoft][ODBC Sql Server Driver]Optional feature not implemented(#0)



Anybody have a clue on what is going on?

I've been trying to solve this for 2 days and am getting nowhere.

[CJ_London]

does the other machines have ODBC set up for the db in question? Not sure why your a re getting an error about SQL server when you have an access db

[RayMilhon]

The other machines do have the ODBC for the db. The data is stored in SQL Server. The front end is MS Access 2010

[CJ_London]

I've not come across this error before so I googled it - here are some links, but there are plenty of others

http://www.coderanch.com/t/299851/JD...river-Optional
https://social.msdn.microsoft.com/Fo...=sqldataaccess

suggest try some of the solutions

[NTC]

the message, which I am not familiar with, would imply that the install of Access lacks an optional feature - - though that strikes me as odd, and sometimes the error messages are misleading. when installing Office 2010 (or just Access 2010) typically I believe the default is now a full install - that wasn't true in the 2003 days - but I could be wrong about this.

I would work at one of the non working PCs; first do a Windows/Office update to be certain your starting point is totally up to date - - then I would
a. use link table manager to relink tables (if you haven't already tried this....)
b. and if that doesn't work then delete the tables of the front end and relink them to the sql server

at this point one is just sanity checking what's going on......