Relative Path to Access mdb

[FriedhelmDrecktrah]

Hi,
how can I set a relative Path in UniConnection.Database for an Access mdb Database file?
E.g. UniConnection.Database:= 'data\MyDb.mdb' does not work.
It only works if I set an absolute path on my development machine, but this path
does not exist on the client computer

Thanks and greetings
Friedhelm Drecktrah

[AlexP]

Hello,

MS Access ODBC driver doesn't support relative paths, therefore you should generate a full path. For example, if the DB file is located in a ..\data\ folder relatively to your application, you can use the following code to generate the path:

UniConnection1.Database := ExtractFilePath(Application.ExeName) + 'data\MyDb.mdb';

[FriedhelmDrecktrah]

Hi,
good idea, thank you!

Greetings
Friedhelm