ms access 97 to apache/php/mysql
Is there an automated way to take an access 97 database and port it to mysql .. and convert the forms for php access using apche? (I have apache/php and mysqld operating on a networked server .. and am now trying to do the port) Thanks Stephen
* Stephen Pearce <g_and_s_pearce(a)xtra.co.nz> [2004-04-27 03:06]:
Is there an automated way to take an access 97 database and port it to mysql ..
Depends on the export options available in Access. Once you have the data outside, then getting them into MySQL should be trivial.
and convert the forms for php access using apche?
I'll be very surprised if such a thing was ever even attempted. Not to mention the resulting code would probably look uglier than homemade soap. -- Regards, Aristotle "If you can't laugh at yourself, you don't take life seriously enough."
Quoting Stephen Pearce <g_and_s_pearce(a)xtra.co.nz>:
Is there an automated way to take an access 97 database and port it to mysql
DTS (Microsoft Data Transformation Services) can do this for you really well. (comes with SQL server). There may be OSS data migration tools, but I'm not aware of them. I found a few ones on the web, but they were all of the $50 USD variety.
.. and convert the forms for php access using apche?
You want something which converts an access windows form (access-proprietary resource, tied to vbscript) to a php webpage (html + php script)? This is like asking for an automated tool to port the linux kernel 2.6 binaries to commodore 64 basic code... If that doesn't make it clear enough, then in a nutshell "shit no, that's impossible bro."
At 13:06 27/04/2004 Stephen Pearce did say...
Is there an automated way to take an access 97 database and port it to mysql .. and convert the forms for php access using apche? (I have apache/php and mysqld operating on a networked server .. and am now trying to do the port) Thanks Stephen
_______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
Hi Stephen, Going through the same thing at the moment with the Clubs Market Day database. The short answer is NO. I am exporting the tables via ODBC and using DaDaBik as the front end. It supports simple data validation but for anything more tricker you need to code it in PHP. If your forms have VERY LITTLE back end code, then DaDaBik or something like it will do, or you can do as I am for one part of the process and that is enter into a MySql table which is exported via ODBC into access and use a module to import the data into the access table.
participants (4)
-
A. Pagaltzis -
DrWho? -
orion＠coke.net.nz -
Stephen Pearce