I work with ACCESS 2000 (as I see in the other FAQ) and I use Microsoft.Jet.OLEDB.4.0 (my connection string is: "Provider=Microsoft.Jet.OLEDB.4.0; Data source="C":\Documents and Settings\Amministratore\Documenti\Siti\mondonovo\mdb-database\mondonovo.mdb" ),
but I have this Error:
Microsoft JET Database Engineerror '80040e14' Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Why? Help me please... Is very Important for me... Thanks...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
Hi Yea, I am at my withs end. I keep getting Microsoft OLE DB Provider for ODBC Driverserror '80040e14' , I have reloaded PWS, Windows, Access and dreamweaver a few times to get everything on my machine working again but no joy, I cant seem to see where I am going wrong or what to do. I am using an access 2000 DB whcih I have used lots before with no problem, it is only when I upgraded my extention manager and had to reload my extentions that this seemed to have happened. I am not too tec savy so can you tell me in a simple way as how to get out of this mess.
Automatically set a session variable with the new record ID
I want to do the same using access 97 or 2000 but getting the same errors as described above - what modifications are needed to the SQL statement to make this work or is there another way of doing this. I have a form which when inserted is inserting aq single row in to the database and am using a uique autonumber field called customerid. I want a confirmatio page to be able to pull the most recently added record using the new record id as a vriable to query the database on the confirmation page. Has anybody got any thoughts on this?