Creating Data Sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Access Form Refresh 1
Word Pointing Different Citations to Same Source 0
Word VBA to update cross-referencing 0
Access Create option group without using wizard? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access 2007 Data Base Compact via VBA 10
Create external database 7

Back
Top