E
Earl Partridge
Access 2000, Windows XP
I'm using what I believe to be a DSNLess connection with:
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
cst = cst & Server.MapPath("/db/mydatabase.mdb") & ";"
set conn = CreateObject("ADODB.Connection")
conn.open cst
And attempting to insert a new record with the sql statement:
Insert into MyComments (Password, EntryDate, Comments) Values ('MyPW', #3/19/09# , 'test')
Conn.execute sql
This is being done live at my host. I get a Syntax Error.
Microsoft JET Database Engine error '80040e14'
At first I thought my date field was the problem, changed that to a text field, etc. I use this
routine in other databases with no problem. I copied & pasted this sql statement as a query
on my local machine and it was accepted.
Perhaps this particular database at my host's site won't accept DSNLess?
Is there another insert method other than "Conn.execute sql"?
Earl
I'm using what I believe to be a DSNLess connection with:
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
cst = cst & Server.MapPath("/db/mydatabase.mdb") & ";"
set conn = CreateObject("ADODB.Connection")
conn.open cst
And attempting to insert a new record with the sql statement:
Insert into MyComments (Password, EntryDate, Comments) Values ('MyPW', #3/19/09# , 'test')
Conn.execute sql
This is being done live at my host. I get a Syntax Error.
Microsoft JET Database Engine error '80040e14'
At first I thought my date field was the problem, changed that to a text field, etc. I use this
routine in other databases with no problem. I copied & pasted this sql statement as a query
on my local machine and it was accepted.
Perhaps this particular database at my host's site won't accept DSNLess?
Is there another insert method other than "Conn.execute sql"?
Earl