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 <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, March 9, 2007 4:48:03 PM
Subject: [nyphp-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
[EMAIL PROTECTED]
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
_______________________________________________
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
