Hi there,

Usually I work with asp in combination with an access database.
However, now I need to work in php and MYSQL.
PHP gives me no problem but MYSQL does.
I can name a database and make dreamweaver recognize it so it pops up in my databindingspanel, but that’s all how far I get.

I don’t know how to make tables and records in the MYSQL-environment.
I hope there are some very clever people who have made a converter which can convert an access database to a MYSQL database. So I can work in the environment I know and just have to convert it in the end to a MYSQL-database and hook it up to the site.

So if you know where there is such a nifty little program that can do this, please let me know.
And if there isn’t then I would be much obliged if someone can advise me a nice book with which I can master MYSQL

Regards


JJ Flash

I don't recommend you do that- first of all, Access if for girls. It's best to start working with professional database tools (MySQL, MSQL, Oracle, Postgre) and stop using desktop-based services like access. the limitations of Access are far too high to make it worth the work.

However if you're inclined to do so, there is a little tool you can use called MyODBC which allows you to connect to a MySQL server using Windows-based DNS connections. Which means you can connect remotely to it via Access and thus export your tables to the MySQL environment. HOWEVER- there are some Access-only (non-standard) datatypes which are not supported by MySQL so some of your data may not pass correctly. Dates for example are stored in the YYYY-MM-DD format in MySQL which will definetly cause a problem with access. And considering that Access is not even consistent enough with dates within its own environment, you're in for some hard work.

The best solution BY FAR is to use a front-end tool (such as MySQL Control Center) to connect directly to your MySQL server and access it and manupulate it like you would Access. Except you're working with a grown-up database and not some desktop limpdick wannabe application which is only good to make barry white CD collection databases.

some links:
---------------------

MyODBC: www.mysql.com/products/myodbc/index.html
MySQL Control Center (frontend system): www.mysql.com/products/mysqlcc/index.html

let me know how you get on. as you may have gathered i don't like Access very much.

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

Thanks for your advise.
I.m just now downloading the tppl you recommend

You always mention the Barry White CD Collection Idea poolio. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

--------------------------------------
www.galleryof3d.com
(PHP & MySql)

Edited by - G3D on 12 Apr 2003 21:09:35