DIADEM - ADO - ACCESS

[Wulfi]

Hi.

I want to read all Data from a mdf file and copy them to Diadem.

I want a 1 to 1 copy from the mdf file, but in diadem.

Has anyone a example?

At the moment I have a Dialog to select the Database and than i get connect to it.

Bun now I don't know how I can get all Table names from the database.

I must read all "SQL_Tables.

Which command must I use.

Here is my connect sub:

Sub AdoConnect()
DIM adModeRead, adUseClient
  'Connects ADO
  'Calls the ADO connection dialog box
  Dim MdbName
  MdbName = Lesen_Datei
  AdoConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MdbName & ";Persist Security Info=False"
  sAdoConnectString = AdoConString
  set oAdoConnection = Nothing
  If sAdoConnectString <> "" Then
    'Creates the ADO connection object
    Set oAdoConnection = CreateObject("ADODB.Connection")
    'Sets ReadWrite mode
    oAdoConnection.Mode = adModeRead
    'Opens connection
    oAdoConnection.Open sAdoConnectString

  End If
End Sub

[TomBaum]

Hi Wulfi,

You don't  have to write a dataplugin for mdf files on your own. This work has been done by our developer. Have a look to http://zone.ni.com/devzone/cda/tut/p/id/4065 or http://ni.com/diadem/dataplugins there you can find dataplugins which you can install in DIAdem and then you are able to load those mdf files.

Regards

TomBaum