dsoderstrom
asked on
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?
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?
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I worked.
Jim.