470,563 Members | 2,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,563 developers. It's quick & easy.

Ms access linked sql server table update problem

Hi All,
1. Created table in SQL Server 2K with Primary key as int Identity
2. Link to table in MS Access 2K with child table
3. Using form in MSAccess to update the both master and child linked table

I want SQL server to automatically update the int identity column as it
would normally. i.e. no need to enter a value even though it is a NOT
NULL field. SQL Server recognises this , allows the row details to be
entered without the int identity and creates it when moving to the next
blank row (in Enterprise Manager) or allows an Insert in Query Analyser
without the int column used (in fact it demands that the int column is
not in the Insert)

How do I update the row in Access, as it returns an error message
saying that the int column cannot be null. The properties cannot be
changed as it is a linked table. I would appreciate help from those
that KNOW the answer as I have tried all the silly ideas such as trying
to set the int identity to NULL in SQL Server (which is not allowed of
course but it was a long shot!)
Feb 27 '08 #1
1 1894
32,295 Expert Mod 16PB
You've managed to put me off from even looking at your question.
Good luck.
Feb 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by gordon.dtr | last post: by
12 posts views Thread by rdemyan via AccessMonster.com | last post: by
5 posts views Thread by Kip | last post: by
4 posts views Thread by xperre van wilrijk | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.