Problem adding records to a linked table in Access.

I am linking to an SQL Server 2008 table in an Access 2010 database.
I am able to update existing data in this linked table but am unable to add records.
I have done the following:

   1) created a timestamp field in the SQL table
   2) created a field in the SQL table with a data type of "int" and the identity specification set to "Yes".  (This becomes an "AutoNumber" field in the linked Access table).
   3) have created a unique index on the field referred to in step 2.  (This becomes a Primary index in the linked Access table).
   4) Have given myself Delete, Insert, Select and Update permissions in SQL Server for the table.

I've set up and linked to many tables like this before and have never had a problem.  Any ideas on what I could be missing?
dsoderstromAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
What happens when you add the record?  and is this in table view or via code, query, etc.

Jim.
dsoderstromAuthor Commented:
Sorry, I should have been more explicit.
I am trying to update/add records to the table via a subform within a main form.  The main form contains header information and the subform contains detail information for each header.  They are linked together by a common field.  As I page through the headers the detail information appears as it should in the subform for each header and I am able to change data in the subform. But, I cannot get a new line to come up in the subform for adding a record.  
On the data tab on the property sheet for the subform I have Allow Additions, Allow Deletions and Allow Edits all set to Yes.
When I first submitted this question I was not able to enter data directly into the datasheet view of the table either.  But I am able to do that now.  Can't think of anything I did that changed this.
dsoderstromAuthor Commented:
I was finally able to get this working.
I mentioned that I had created a field in the SQL table with a data type of "int" and the identity specification set to "Yes".  Since this field becomes an AutoNumber field in the linked Access table I did not include it as a field in the subform.
I added this field to the subform. On the Open Event for the subform I entered "Me.LineIndex.ColumnWidth = 0" so that the field would not appear on the screen.
This fixed the problem.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dsoderstromAuthor Commented:
I worked.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.