PDA

View Full Version : Dreamweaver and Microsoft Access


emh76
01-28-2010, 08:05 PM
The company I work for currently has their intranet designed with FrontPage. We have an access database that we use for the company directory and that is where we make changes too. This database is linked to the website, asp files I believe..... Anyways, We are going to make a new Intranet page with Dreamweaver CS4, Should I still use the database to keep up with our directory or something else, what would be easiest? Also, I did read somewhere on how to create data access pages, they save in html format and I even did some sample runs.....but the attached screen shot is what I got.....if I should keep doing it this way, any suggestions on how to fix this where it would fit in right pane?

edbr
01-29-2010, 12:03 AM
there should not be a problem using dreamweaver to do this , as long as you can connect to the database you can manipulate the data.
i must say i have never used access in this way but i am sure it is possible
i do something similar to this but i use an apache server using php and mysql database, ( personal choice there) but converting the existing database to mysql might be a daunting chore I expect,
you can always download a 30 day trial of dreamweaver to experiment

tux
01-29-2010, 07:50 AM
Good advice from Edbr. Mysql is much more robust and secure than Access.

If you are thinking of trying to convert your DB to Mysql then here are some resources that may help.

http://www.bullzip.com/products/a2m/info.php

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

http://www.ehow.com/how_2058142_convert-access-mysql.html

http://www.wampserver.com/

Not ever had to do a conversion though as have always used Mysql.

Good luck with it.

Regards Paul