Replies Back to Article

Insert Page and Auto-Number

errors using this script

August 28, 2001 by Michael Talbot

I keep getting the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/registration/formtest.asp, line 107

It refers to these lines:
Recordset.Update
Recordset.MoveLast

GREAT

September 23, 2001 by Werner BH

Great! But... what about EDIT record?

I must be stupid.

October 16, 2001 by Kevin none

I can not seem to get this to work. Is there any better documentation on using the extentions? Do you need to use both?

What I am trying to do is insert a record, get the auto ID from Access and pass that to the next page which is a picture upload.

Also does this require the Jte OLEDB Provider or can it work with the MDB driver?

Thanks

Found something on Macromedia.com/support

January 17, 2002 by ed hidden

I saw a way to do this on Macromedia.com/support/ultradev. I forget the actual technote, but I do remember them saying if you change ONE word from the Insert/Update or Delete behaviors it will passt eh Query String Values onto the redirect page.

If there are further questions, I'll grab the actual URL and post, but it's easy to find with a search.

-Ed

How reset the AUTONUMBER ACUMULATE IF DELETE RECORDS?

April 13, 2002 by Luis Castillo

THE CODE WORK FINE, BUT IF DELETE RECORDS AND INSERT KEEP ACUMULATE VALUE OF AUTONUMBER, WHERE I CAN RESET TO 1? AND HOW?

Dreamweaver MX

September 21, 2002 by tom fox

Does this extension work with dreamweaver MX? Everytime I try t use it I get an error that says

Javascript error while loading insertAutoRecord.htm unable to open the script file "../EditOperations.js(error2).

Anyone know a fox to this problem?

RE: Dreamweaver MX

October 4, 2002 by Jared Cobb

I get the same error. I don't believe this extension is compatible with DWMX, so I would suggest doing it by hand. =( Maybe he'll release an update soon though.

Works perfect!!!

October 14, 2002 by Rene Bommezijn

Doubleclicked the extension, restarted Dreamweaver, inserted the "insertautorecord"-behaviour, called session("ID") on the redirect-page..... and there it was. Great!

RE: Dreamweaver MX

December 21, 2002 by Donald Kleinsmidt

theres a fix for a similar extension (George's one) which u could use but u would need this fix suggested on this page ... http://www.newmanzone.com/recipes/recipe.asp?LinkID=2&Link=index2.htm

i hav a feeling that the fix may also work for this extension too (havent tried) cos its da same error