 Jesper wrote:
ok... I've figured it out.
There's a bug in the creation of tables on the MSSQL server on Borg's behalf.
The Author_ID column in the tblAuthors table is set to 'integer'. In
the Access version this is 'autonumber'. I set the Identity property of
the column to 'Yes', Identity seed to 1 and finally Identity increment
to 1.
That fixed that problem  ... I'm not too sure if that solution causes other problems ? Borg? |
There isn't a bug in my SQL server creation file, see the following
line from the file sets the Author_ID field to interger; Indentity,
incrementing by 1 and not allowing nulls:-
strSQL = strSQL & "[Author_ID] [int] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ,"
Topic Options
Post Options
Thanks(0)
