I need advice on a problem we are having.
We have created an ODBC connection to a SQL server 2000, via Access 2000. We are able to open and read/write to all tables except 3. When we try to open these we get and ODBC -- Failed message box and the data is showing as "name" in the fields.
Can anyone advise what the problem can be. I thought it could be permissions, a colleague of mine thinks keys. Can anyone shed any light on this one please.
Any help is always appreciated