Problem with SQL Server 2005 linked table in Access 2003

[hedgracer]

I have a linked table that is set up in SQL server 2005 to have default characters in each column. When I enter the following 'A' in Firm, '480' in Office, nothing in Sales Series, and .04 in Rate and hit tab I get this:

Firm Office Sales_Series Rate
A 473 XXXXX 0.04
A 474 XXXXX 0.04
A 476 XXXXX 0.04
A 477 XXXXX 0.04
A 478 XXXXX 0.04
#Deleted #Deleted #Deleted #Deleted

When I close the table and open it again the row I entered is there complete with the default 'XXXXX' for Sales Series. Why is this happening and how can this be fixed? I need to defeat this for data entry purposes. Any help is appreciated. Thanks.

Dave

 

[PHV]

Does access recognize the primaryKey of your linked table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hedgracer]

I deliberatly did not put a primary key in this table since I felt this may cause a problem.

 

[PHV]

So, you deliberatly didn't want to let access update this table ?
Since when a PK cause a problem ???