query SQL-server/database via VBA ???

  • Thread starter Thread starter hpesata
  • Start date Start date
H

hpesata

Hi!

I am writing an ACCESS 2003 ADP app which connects to a Sql Server
2005 Express Edition database. to enable my user to login to the
database, I ask him to enter the name of the server (instance),
database, username and password.

is there any way to query available sql-servers/databases via VBA and
display them in a combobox so my user can select one of them ?

any help with this would be greatly appreciated, thanx in advance!

regards,
Hans
 
Hi Tom!
yeah you can do this with SQL DMO I thnk
also I know I can browse available servers using code atwww.freevbcode.com
I do know that the NorthwindCS.adp includes a bunch of sample code for
programmatically changing a connection; I reccomend you look at that code
Click to expand...

thanx a lot for Your reply, I will check this out!

regards,
Hans
 
yeah you can do this with SQL DMO I thnk

also I know I can browse available servers using code at www.freevbcode.com


I do know that the NorthwindCS.adp includes a bunch of sample code for
programmatically changing a connection; I reccomend you look at that code
 
Back
Top