access database update

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

access database update

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> Microsoft FrontPage Help >> access database update

Page: [1]


donisak Posts: 6 Joined: 9/14/2005 Status: offline	access database update - 9/14/2005 9:49:36 i am trying to update an access database following the example in microsoft article 240090 rev 2.0. i am updating 1 column "Action". UPDATE subactionlist Set Action='%%Action%%' Where ID='%%ID%%' when i access the update_form.asp page it displays the ID of the first record and blank for Action (it's blank in database). when i type in 5 for ID and no for action and click on update, the form goes back to 1 and blank and does not give an error but does not update the database. i am testing this on a hosted web site that is set for front page extensions etc and using other pages in the web i can perform select queries with no problem. what am i missing? don


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: online	RE: access database update - 9/14/2005 15:16:34 Try : UPDATE subactionlist Set [Action]='::Action::' Where ID=::ID:: _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to donisak)


donisak Posts: 6 Joined: 9/14/2005 Status: offline	RE: access database update - 9/14/2005 16:21:30 thanks spooky, tried what you suggested and it did not help. i also went into subactionlist and put a yes in the action column for ID number 1. when i do an update it still comes back as a yes. don (in reply to donisak)


donisak Posts: 6 Joined: 9/14/2005 Status: offline	RE: access database update - 9/14/2005 19:27:01 thank you for the help. i figured that i was not sending info to the update page and checked my form. found that somewhere in my troubleshooting the action box in form properties went blank. put update.asp in there and now my db updates. thanks again (in reply to donisak)