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