Solved

DSN Less Connection to a access database

Posted on 2002-07-18
3
128 Views
Last Modified: 2010-05-02
Hi

I have a access data base .I need to create a dsnless connection to it.Can anybody help
0
Comment
Question by:Vignette
  • 2
3 Comments
 
LVL 43

Expert Comment

by:TimCottee
ID: 7161706
ADO or DAO?

For ADO:

Dim myConn As ADODB.Connection
Set myConn = New ADODB.Connection
myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myfolder\mydatabase.mdb;Persist Security Info=False;"
myConn.Open
0
 

Author Comment

by:Vignette
ID: 7161749
One more question befor i give you the points.

How do you get a list of the tables in the access database
0
 
LVL 43

Accepted Solution

by:
TimCottee earned 50 total points
ID: 7161767
Simplest way is this with the above code:

Dim rstTables As ADODB.Recordset
Set rstTables = New ADODB.Recordset
rstTables = myConn.OpenSchema(adSchemaTables)

Then you can use the recordset and the various fields returned such as "CATALOG_NAME", "TABLE_NAME" etc to get the required information.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question