Trying to create a Access 2007 (*.accdb) with TUniConnection

[tkoscielski]

With TUniConnection, I am able to create a 2002-2003 *.mdb file on the fly. I just do the following and it works. The file is created and I can go forward.

Code: Select all

UniConnection.ProviderName := 'Access';
UniConnection.Database := 'c:\temp\database.mdb';
UniConnection.SpecificOptions.Values['ForceCreateDatabase'] := 'True';
UniConnection.SpecificOptions.Values['DriverVersion'] := 'dvAuto';
UniConnection.Connect;

Now in order to get the newer Access 2007+ (*.accdb) format to work, I have tried the following code, but first I had to make sure the Microsoft Access Database Engine 2010 Redistributable is installed (https://www.microsoft.com/en-us/downloa ... x?id=13255).

Code: Select all

UniConnection.ProviderName := 'Access';
UniConnection.Database := 'c:\temp\database.accdb';
UniConnection.SpecificOptions.Values['ForceCreateDatabase'] := 'True';
UniConnection.SpecificOptions.Values['DriverVersion'] := 'dvAccdb';
UniConnection.Connect;

However, when the above code runs, it still creates a 2002-2003 Access DB format.

I have verified that TUniConnection can open the 2007 Access DB format for which I created the file with Access 2016. It just looks like it can't create it with Delphi.

Is there something else that I can do to get this to create a newer Access DB format.

[MaximG]

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next UniDAC build. Currently, we can send you a night build of UniDAC with the fix. For this, please specify your license number and the exact version of Delphi you are using via the e-support form ( https://www.devart.com the "Support"\"Request Support" menu)

[tkoscielski]

Thank you for the quick reply. I am happy to see that it will be in the next release. Knowing that it'll be in the next release should be good enough for my project.

[MaximG]

We were glad to help you. Please don't hesitate to contact us with questions concerning UniDAC usage.