NYCPHP Meetup

[Susan Shemin]

Hey, Timothy,

Do you only want to convert it to a MySQL database?  If so, each access table is just an MS Office table (same as an Excel spreadsheet).  You can export each table into a CSV file from Access and create each field name as a MySQL field and just import the data into MySQL as importing a CSV file in PHPMyAdmin.

If you want to keep it as an Access database, I know it can be done.  I googled PHP MSAcess and here's two links:

http://www.configure-all.com/php_access.php

http://www.web-max.ca/PHP/odbc_2.php
 


----- Original Message ----
From: Timothy Boyden <tboyden at supercoups.com>
To: talk at lists.nyphp.org
Sent: Friday, March 9, 2007 4:48:03 PM
Subject: [nycphp-talk] Microsoft Access application conversion recommendations


Hi All,
 
I will be starting on a project to convert a fairly extensive Microsoft Access based application to a web based version. This application was internally built to manage all manner of details regarding our franchisee operations (financials, reporting, CRM, etc..). It uses MS Access forms with a tabbed structure and various form elements. The application will be hosted on a Network Solutions shared hosting server that has an Apache 1.x, MySQL 4.1.x, and PHP 4.1.x back-end. The MS Access application uses an MS SQL 2000 Enterprise database for data storage.
 
I could use some recommendations on tools that will help me convert this app as quickly as possible. Everything from IDEs to conversion utilities are on the table. Unfortunately changing the web infrastructure is not.
 
Traditionally I code and manage my app files using Macromedia Dreamweaver.
 
Any advice would be greatly appreciated.
 
Regards,
 
Tim Boyden
 
--------------------------- 
Timothy Boyden
Network Administrator
tboyden at supercoups.com
SuperCoups®
 
350 Revolutionary Drive | E. Taunton, MA 02718
508-977-2010  | www.supercoups.com 
 
We Support Alex's Lemonade Stand Foundation, 
“Fighting Childhood Cancer One Cup At A Time”
Donations Accepted at: www.firstgiving.com/SuperCoups
---------------------------
Local Coupons. Super Savings.®
 
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070309/f78616a7/attachment.html>