switch forms between diff. databases

[giovi2002]

I have 2 different databases which have the same datamodel and same user-interface. I don't want to put the data together because both might become different in the roadmap for the applications.

But for now a user is asking me to make one application with a switch button between the applications. I don't know whether it's possible: both databases reside on the same server and have the same user/pass login which my application uses. In my adp connection I need to choose one database, is it possible to 'switch' the connections in the application?

 

[Di0genes]

Yes, its possible:

CurrentProject.OpenConnection str_Connection, User, PW

is the thing you are looking for.

Regards
Diogenes