[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

DSN Less Connection to a access database

Hi

I have a access data base .I need to create a dsnless connection to it.Can anybody help
0
Vignette
Asked:
Vignette
  • 2
1 Solution
 
TimCotteeCommented:
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
 
VignetteAuthor Commented:
One more question befor i give you the points.

How do you get a list of the tables in the access database
0
 
TimCotteeCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now