SQL 2000 Linked Table

[tkosel]

I have a Access 2003 front end that is linked to a SQL 2000 database table.
(Which was upsized from Access 2003.) For some reason, I cannot add records
to the SQL table from Access. I can use the SQL Enterprise manager to add
records to the table, but cannot add records in access. I can see the data
in the table using access, but cannot add records. What am I missing?

 

[Duane Hookom]

Can you edit records? Does the SQL Server table have a primary key defined?
Does Access know about the primary key?

 

[Roger Carlson]

My guess is that you have Bit fields in your SQL Server table that take the
place of the Yes/No fields in Access. If so, you have to have a Default
value in them, because a Null in a Bit field in a SQL Server table confuses
Access.

Check out this MS Knowledgebase article:
http://support.microsoft.com/kb/280730/EN-US/

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[tkosel]

Duane,

Thanks for your response. The answer to all questions is yes. I did find
another post that led me to the solution. I need to have a timestamp field
in the SQL table(s). When I created that field, averything works fine. When
I upsized, I chose to let the wizard decide if it should create a timestamp
field and it didn't do it for the affected table(s). I ran the wizard again
and told it to ALWAYS create the timestamp field. That forced it to do it.
Don't really know why the field is needed, but it is a pretty easy fix.
(Don't uderstand the significance of the field!) Thanks again!!!!