Hello,
I have created a database in MS SQL Server that contains various tables. I am trying to use Access Forms to create an interface to allow records to be managed and have come across a problem that I hope I can get some help with.
The SQL Server table contains a field which is auto-populated with an integer value when a new record is created.
The SQL Server definition for this is valueid int IDENTITY(1000,1)
The first record created has valueid set to 1000, the second 1001 etc.
This works ok when inserting records using SQL statements in SSMS.
I have created an Access file and linked to the SQL Server table.
I am able to view records in the linked table in an Access form which displays the valueid field plus other fields.
My problem is adding new records - my form has a text box which I want to display valueid for existing records but adding it to the form seems to stop new records being added.
Is there a way to accomplish what I want? - I hope I have explained it ok.
I have created a database in MS SQL Server that contains various tables. I am trying to use Access Forms to create an interface to allow records to be managed and have come across a problem that I hope I can get some help with.
The SQL Server table contains a field which is auto-populated with an integer value when a new record is created.
The SQL Server definition for this is valueid int IDENTITY(1000,1)
The first record created has valueid set to 1000, the second 1001 etc.
This works ok when inserting records using SQL statements in SSMS.
I have created an Access file and linked to the SQL Server table.
I am able to view records in the linked table in an Access form which displays the valueid field plus other fields.
My problem is adding new records - my form has a text box which I want to display valueid for existing records but adding it to the form seems to stop new records being added.
Is there a way to accomplish what I want? - I hope I have explained it ok.