By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,190 Members | 802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,190 IT Pros & Developers. It's quick & easy.

Ms access linked sql server table update problem

P: 1
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
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
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.