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

Martin

Hi Martin,

What are the names of the tables? Maybe they are using reserved names like User?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Or possibly datatypes that Access can't handle such as XML. Try using the linked table manager to check and refresh the connection details.

--

Joe (Microsoft MVP - XML)

Sorry for the delay in responding and thanks for the feedback. I will take it away and see what happens