Importing Access Database

Question

I have built a database in Access which allows me to import a
list of file names hundreds at a time into a table. My ultimate
goal is to import that table in to Coldfusion, and allow users to
be able to make changes to that list (for example, make a note who
updated that file and when they did so). I have added the Access
file as a data source in Dreamweaver, but I have hit a road block
as I am unsure where to continue from here.

As a preface, I have some, although minimal experience with
Dreamweaver and ColdFusion and I have been working with the
Macromedia ColdFusionMX7 Web Application Kit book.

Thank you in advance for your help and direction.

Jim_Gibson_sbswa_com · Answer

I recommend that you do the examples in chapter 14 of the book you are using, if you are not quite comfortable with implementing data-driven pages. Ignoring any Dreamweaver tricks for the moment, you can simply code ColdFusion in Dreamweaver's "Code" view: define a query to retrieve your filenames and the comments, and populate a form (not an html table) with them, a limited number of records at a time. Then when users update the comment fields and submit the form, your form action template will do an update query to put the records back with their updated comments.

Once you have that working, you can go through Dreamweaver tutorials that will help you to understand how Dreamweaver can assist in coding queries, etc.

With the basic application working, you will want to explore more advanced controls for presenting large tables of data for updating, instead of simple form fields. For example, with a Flex solution you would probably use a datagrid control to bring up a large number of your file records for editing.

Jim

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.