I am creating an application that will use a couple of local Access Database tables. These tables will be in principle for use solely by this application.

I know how to create the database initially, but how do I set it up when I distribute the application ? Can this be done by an install utility (I also may need to create a dsn) Or do I need to do it programatically when I run the application, and make it detect whether the tables exist or not... (if yes, any guides on how to do this ?)

Everything may not be explained in this NG, but any pointers to good books on the subject will be appreciated...

Thanks !