Importing access databases at run-time?

[whitehandkerchief]

hiya, I'm working on an app to do mail merge at the moment, got a bult in BDE database so addresses etc can be added from there. But was wondering if neone knows a way that the user could import their own access database at run-time...ne ideas? cheers
whitey

 

[bbegley]

If you mean to let the user browse to an access database to connect to, I think you can set up a database on your machine, and use an opendialog component and change the connection string to match the database they selected at runtime (set connected to false in design mode). I am assuming that you already know the structure of the database. If you do not, then I imagine you have to programatically create the table/query objects, which I have never done.

Brian
"There are 2 kinds of people in the world, those that divide people into two groups and those that don't. I belong to the second group." - tag line I stole