Search results

  1. J

    Entering a new record using an Access form for a linked table in SQL Server that uses an auto-incrementing primary key

    Thanks everyone - particularly bastanu for testing the approach he suggested. I am not easily able to change the structure of the SQL Server DB to use IDENTITY rather than GUID as a whole lot of work in other systems has been done to integrate with the DB using GUI. The actual use case for...
  2. J

    Entering a new record using an Access form for a linked table in SQL Server that uses an auto-incrementing primary key

    Thanks for the responses everyone. I can provide a bit more detail which hopefully will make things clearer. Below is a screenshot of how the table is scripted in SQL Server. It is the last column - MenuIndex - that is the problem. When a new record is created the MenuIndex field gets...
  3. J

    Entering a new record using an Access form for a linked table in SQL Server that uses an auto-incrementing primary key

    Thanks for the responses. Maybe I need to give some more background. The SQL Server table in question has a primary key that uses the GUID data type. This does not need to appear on any Access form. The Access front end was working fine to view/add/delete records but my customer wanted a new...
  4. J

    Entering a new record using an Access form for a linked table in SQL Server that uses an auto-incrementing primary key

    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...
Top Bottom