How to install a database?

[Richard_Meijeringh]

Hello,

for my application I am using an Access database. This application has to be installed on a client computer and I need to build an installer for my application. As part of the installation I want to install an Access Database, which must automatically be configured so it will be ready to use. Has anyone experience in using and installing databases with stand-alone applications?

Best regards

Richard Meijeringh

[Anil_Reddy]

Hi,

Access database comes with a license Key. How do you want to handle that situation?

You can call setup.exe of MS-Access after installation of your application. But you can not handle activation part of that.

You should buy a license each time and give it to customer.

Anil

[ceties]

 I am not sure if I fully understand you but if you have acess database (i.e. *.mdb file) just add it when building your application. It's as easy as that. Just be sure you put it to the righ destination.

[Anil_Reddy]

Hi Richard,

If you do not want the user to open the access database anytime.....you can just add .mdb file to ur installation files. and mention the destination as you mention for other supporting files.

Your application works even if the client does not have Access database. But the thing is, If user wants to open the database and do manipulations, he can not do untill he install MS-Access with license.

Anil

[jcarmody]

This gives you the opportunity to offer controlled access to the database; you can write an interface that includes validation.

[Peter_Schutte_NINL]

Hi Richard,

As said above, you can use an .mdb file as the database

But this depends on the use of the database. Can you tell us more about the way you've planned to use the database? This would make it a lot easier to help you.

Best regards,

Peter S

[ceties]

If your application works the way: Connect to DB-do something-close the DB just add the db to your distribution (the mdb file). The interface to the DB is provided via the ODBC in widows so you don't need to have the Access installed on the target machine.