CodingForums.com - View Single Post - Should I use my existing Access database or create a new mySQL database?

MaDmiX · 02-21-2012, 06:42 PM

Hi All,

I am developing a web application based on a desktop application that I created in Microsoft Access. Initially I had planned to create a new database in mySQL and connect my web app to that but I recently found that I can connect to my Access db using ODBC and build the web app on that.

My dilemma is whether that is the best approach. I would like to build it using Dreamweaver in PHP and JavaScript because I know that VB script is only compatible with Internet Explorer. I tried connecting to my Access db in Dreamweaver and it was very difficult. I was only able to do it using an ASP page and Dreamweaver only supports mySQL connections with PHP. I am fairly new to web developing and I want to ensure that I make this as flexible as possible and not be tethered to Microsoft but the idea of keeping my data and db structure is very appealing. I don't have a problem with recreating it in mySQL if that is the best approach.

I was hoping I could get some guidance from the experts.

Thanks in advance for your support.

Ken

02-21-2012, 06:42 PM	PM User \| #1
MaDmiX Regular Coder Join Date: Feb 2012 Location: Charlotte, NC Posts: 104 Thanks: 26 Thanked 0 Times in 0 Posts	Should I use my existing Access database or create a new mySQL database? Hi All, I am developing a web application based on a desktop application that I created in Microsoft Access. Initially I had planned to create a new database in mySQL and connect my web app to that but I recently found that I can connect to my Access db using ODBC and build the web app on that. My dilemma is whether that is the best approach. I would like to build it using Dreamweaver in PHP and JavaScript because I know that VB script is only compatible with Internet Explorer. I tried connecting to my Access db in Dreamweaver and it was very difficult. I was only able to do it using an ASP page and Dreamweaver only supports mySQL connections with PHP. I am fairly new to web developing and I want to ensure that I make this as flexible as possible and not be tethered to Microsoft but the idea of keeping my data and db structure is very appealing. I don't have a problem with recreating it in mySQL if that is the best approach. I was hoping I could get some guidance from the experts. Thanks in advance for your support. Ken