Developing in Access, inserting into table 1 with an identity with a
trigger that inserts a record into table 2 also with an identity,
Fixed this by setting up a dummy table 3 with an identity, grabbing
IDENTITY_INSERT ON for table 3 and inserting the original identity
Any user running this gets:
Msg 8104, Level 16, State 1
Current user is not the DBO or object owner for table 'Set_ID', unable
to perform SET operation
I also tried putting the IDENTITY ON statement in a stored procedure
and giving rights to the sp to the user, to no avail.
On-line Help mentions SET IDENTITY use in triggers. How do I give db
users rights to set this property on my table?