Oprettelse af access database tabel
Hej jeg kan ikke få denne oprettelse af en tabel til at virke!-----------------------------------------------------------
Set Connection = Server.CreateObject( "ADODB.Connection" )
DatabasePath = "DBQ=" & server.mappath("../data/Familie_Kalender.mdb")
Connection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DatabasePath
Sql = "CREATE TABLE kalendertest(dagen TEXT, maaneden TEXT, aaret TEXT, begivenhed TEXT)"
Connection.Execute Sql
Connection.Close
Set Connection = Nothing
-----------------------------------------------------------
Jeg får denne fejl når jeg kører det:
-------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.