[AccessD] ADP

The question as asked is a little bit ambiguous. You could mean, when
creating the ADP -- in that case the wizard lets you pick the database.
Or you could mean that you want the user to be able to switch from one
version of the database to another, on the fly. In this case, create a
reference to the SQL-DMO library, which contains a bunch of useful
objects for this sort of thing. I have code in an app I did a while back
that lists the servers available in a listbox, then the databases of the
selected server in another listbox, and lets the user connect to the
selected database, basically by creating a new connection object. This
route risks ungracefulness, however, since in theory the user could
select a completely inappropriate database and have your pretty Access
ADP application blow up unmercifully. We got around this by naming the
parallel databases using a naming scheme, so then we could eliminate any
irrelvant databases before populating the listbox.

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carlo van der
Zon (Access IT Training)
Sent: Wednesday, September 15, 2004 8:59 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] ADP


Hi Group,

Does anybody know how to choose de SQL database in a ADP Runtime?

Thanks
Carlo

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com