Page 1 of 1

Autoincrement field in MS Access table

Posted: Wed 07 Oct 2009 09:15
by oz8hp
I am trying to use an MS Access 2000 table with the newest version of UniDAC but I am having troubles with an autoincrement field.
I have a grid (from the Devart package) on a form where one of the fields is auto but when using MS Access it doesn't increase and I get an error saying that field should be filled out.
If I shift to MySQL db then it works.

Are there some specific options that I need to set.

Re: Autoincrement field in MS Access table

Posted: Wed 07 Oct 2009 16:17
by hendrang
oz8hp wrote:I am trying to use an MS Access 2000 table with the newest version of UniDAC but I am having troubles with an autoincrement field.
I have a grid (from the Devart package) on a form where one of the fields is auto but when using MS Access it doesn't increase and I get an error saying that field should be filled out.
If I shift to MySQL db then it works.

Are there some specific options that I need to set.
Set properties Options.RequiredFields to False.

Posted: Thu 08 Oct 2009 06:43
by Plash
We'll add support for autoincrement fields in the next UniDAC build.

Posted: Thu 08 Oct 2009 10:34
by oz8hp
The Options.RequiredFields set to false does the trick for now.

As always looking forward to next version.

UniDAC is the best money I have spend on software in many years.