Create a Access Database at runtime

[kaiserilich]

Hi,

I need create a empty access database at runtime execution. I try to create directly using the ExecSql from the UniConnection but doesn't work...

Code: Select all

Connection.ExecSQL('CREATE DATABASE c:\temp\tmp.mdb');

how I can create the database on execution time? is possible?

using:
Delphi 6 up 2
unidac 5.3.9

thanks a lot

[AlexP]

Hello,

To create a new DB, you should set the UniConnection1.SpecificOptions.Values['ForceCreateDatabase'] option to True, and specify the new DB file in the DataBase property. When opening connection, a database will be created automatically.

[kaiserilich]

Hello,

To create a new DB, you should set the UniConnection1.SpecificOptions.Values['ForceCreateDatabase'] option to True, and specify the new DB file in the DataBase property. When opening connection, a database will be created automatically.

Thanks a lot.!

[AlexP]

If you have any further questions, feel free to contact us.