Using ODBC to connect Access 2003 to sql server 2005 express

[tedpottel]

Hi,

I am trying to join a access to my sql server. I made the ODBC
connection ok and was able to bring the table up in Access, but.
All the fields had #deleted in them. When I added new data in access,
it should up on my sql server ok, but if I refresh the access spread
sheet, the new data I entered got replace with #deleted.

I did some resercah and found a comment about Access not knowing the
key index, I open it in design vue and it had the key logo next to the
id column.

I need help!!!!!
-Ted

[Brian Conner via SQLMonster.com]

Answer: Chances are you are linking to a table that either does not have a
primary key or Access does not recognize the primary key.

Try deleting the linked table and relinking it. A window should appear that
allows you to select the fields that identify the unique records.
Select the fields that make up the primary key or if in doubt, select the
first 10 fields. Access will not let you choose more than 10 fields to
identify the primary key.

--
Brian Conner

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200912/1

[Mary Chipman [MSFT]]

See if the following KB article helps solve the problem:

http://support.microsoft.com/kb/128809

--Mary

[tedpottel]

On Dec 29, 12:02 pm, "Brian Conner via SQLMonster.com" <u47161@uwe>
wrote:

> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2009...

Thank you for your help,
it seems like access does not like a bigint for the key value, chnage
all my indexes to int and it works fine!!

[tedpottel]

On Dec 29, 12:13 pm, "Mary Chipman [MSFT]"

> >-Ted- Hide quoted text -
>
> - Show quoted text -