Autoincrement field in MS Access table

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

[hendrang]

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.

[Plash]

We'll add support for autoincrement fields in the next UniDAC build.

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