ghell
04-13-2004, 04:48 PM
i am trying to make a script to make access databases for me. i dont know if this is possible but i looked around and there is something like this:Set conn = Server.CreateObject("ADODB.Connection")
conn.Execute("CREATE DATABASE database_name")
Set conn = Nothing
but that returns the error Operation is not allowed when the object is closed.
so i tried to addconn.Open("DRIVER={Microsoft Access Driver (*.mdb)}")which gave the error Operation was canceled.
next i tried replacing that withconn.Open("provider=Microsoft.jet.oledb.4.0")instead but that gives the error Authentication failed.
anyone know if this can be fixed?
conn.Execute("CREATE DATABASE database_name")
Set conn = Nothing
but that returns the error Operation is not allowed when the object is closed.
so i tried to addconn.Open("DRIVER={Microsoft Access Driver (*.mdb)}")which gave the error Operation was canceled.
next i tried replacing that withconn.Open("provider=Microsoft.jet.oledb.4.0")instead but that gives the error Authentication failed.
anyone know if this can be fixed?