Creating Data Sources

M

MChrist

How would I go about checking via VB is a data source exists or not? If the
source doesn't exist, can I create one in via VB? Is it necessary to even
have the data sources if I have the server information, can I just use vb to
link to the table without the data source?

If you could point me to any examples, that would also be greatly appreciated.

Thanks

Mark
 
S

solex

Mark,

If you are connecting to SQL server or any other source and you know (1) the
server name (2) the database (3) a valid username (4) a corresponding valid
password then you can simply use ADO and the connect string to open the
datasource, here is a reference to connection string syntax for various
sources: http://www.able-consulting.com/ADO_Conn.htm

Dan
 

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

Link a text box based on drop down box with four options MS Word 365 0
Creating a Chart on form from selected data in query. 0
Merge field truncated to first 18 characters from source? 0
You'll need a new app to open this about link 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
How do I clear a form? 0
Copying Portions of Data 0
How to create absolue path link to another workbook (Excel 2003) 1

Top