Option Explicit
Public Function CreateMDB(varsMDBPhatName As String, varsMDBFileName As String, _
varsTableName As String, _
Optional variDB As Integer = 1, Optional bFirstFieldIsID As Boolean = True, _
Optional bOverwriteMDB As Boolean = True) As Boolean
Dim varsMDBPhatWithFileName As String
On Error GoTo err_flash
Err.Clear
' MDB PhatName & FileName
varsMDBPhatWithFileName = SetVarsPhatWithFileName(varsMDBPhatName, _
varsMDBFileName)
' Falls MDB vorhanden evtl. löschen, ansonsten Exit & Error
If IsFilePath(varsMDBPhatWithFileName) Then ' modIsFilePath.IsFilePath
' Funktion
If bOverwriteMDB = True Then
' Alte Datenbank zuvor löschen
Kill varsMDBPhatWithFileName, True, True ' modKill.Kill Funktion
Else
' Datenbank existiert, Abbruch durch nicht Überschreiben der
' Datenbank
CreateMDB = False
Exit Function
End If
End If
Dim objCatalog As Object ' Objekt erstellen
' Neue leere Datenbank erstellen
' Quelle:
' http://www.vb-fun.de/cgi-bin/loadframe.pl?ID=vb/tipps/tip0322.shtml
Set objCatalog = CreateObject("ADOX.Catalog")
objCatalog.Create "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & varsMDBPhatWithFileName
Set objCatalog = Nothing ' Objekt entfernen
' Datenbank öffnen
OpenMDB varsMDBPhatWithFileName, variDB
' Tabelle anlegen
sSQL(variDB) = "CREATE TABLE " & varsTableName
If bFirstFieldIsID = True Then
' Primär Schlüssel ID erstellen
sSQL(variDB) = sSQL(variDB) & " (ID COUNTER NOT NULL " & _
"CONSTRAINT PK_ID_no PRIMARY KEY)"
End If
oDB(variDB).Execute sSQL(variDB) ' Felder in Tabelle anlegen
' Datenbank schliessen
CloseMDB variDB
Exit Function
err_flash:
MsgBox Err.Description, vbCritical, "Hinweis - modADOdb.CreateMDB"
End Function
Public Function SetVarsPhatWithFileName(varsPhatName As String, varsFileName As _
String)
SetVarsPhatWithFileName = varsPhatName & _
IIf(Right$(varsPhatName, 1) <> "\", "\", "") & _
varsFileName
End Function*greetz*
Tim
.
http://www.DotNetWorld.de |