Updating MS Access from webpage designed in Dreamweaver CS4

Report · Jul 04, 2009

I am trying to create a webpage that we can add, delete, and change information in a Microsoft Access database. I have the add and delete pages working great, but cannot get the update page to work. Has anyone had issues with this and know what I need to do to fix? I have designed the page according to the Dreamweaver webpage instructions.

Report · Jul 06, 2009

I had a similar question when I first started trying to build a data driven website a while ago.

While MS Access is nice for learning the basics behind a database, it is not the best choice for a website. If you feel confident enough to learn a server side language such as php or asp (which you need to give yourself a good amount of time to do) then there are great books, some classes in local colleges/universities and the web that you can use, along with help from forums like this. And you can do it.

However, if you don't feel confident in learning a programming language and getting it to interact with a database, it is time to start budgeting for a professional.

There are a lot of ok do-it yourself books for programs like MS Access, but, if you want something that will work, well, and look great, you need it done with better tools, and by someone who knows how to use those tools.

Many professionals are willing to give free estimates and quotes. Some even list their prices on their website.

If you choose to tackle it yourself, congrats and good luck! If you choose a professional, make sure they have examples to prove they know what they are doing.

Report · Jul 07, 2009

Did you use the update record wizard? That works well.

In what way is the update not working? If it's because the content of the record isn't populating the text areas etc, then it might be because you need bind the data to the field. To do that, select the text area and hight light the recordset field item you need from the bindings panel and then click insert.

Mat