query SQL-server/database via VBA ???

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
 
H

hpesata

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
 
T

Tom Wickerath

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Database Diagram not showing up as an access object 1
Adodb connection to different SQL SERVER DB 3
Different @@SPID for same user/connection ?!?!?! 1
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Access 2000 ADP and SQL Server 2005 2
Access 2007 and ADP to SQL Server 2005 in Vista 12
Get domain username 2

Top