Database Conversion.

**cavedude** · #1 05-20-2005, 02:53 AM

Hmmm, I honestly I really don't see a real use for this. From the screenshots, it looks no different from editing the database with MySQL Control Center. Perhaps you have some use in mind that I overlooked?

sdabbs65 · #2 05-20-2005, 04:39 AM

Most access database users don't need to know SQL.
Anyone who has built anything in access even the most basic of queries using the Access query design window has already been using SQL without knowing it.
Access contains many tools and wizards that hep the user create a powerful database without having to learn SQL.
then it can be converted to SQL rather easy.
I was Basicly trying to make it a bit more easy to edit the database.
since so many people have Issues useing SQL.
not sure if it will be of help or not.
but it is another way of doing things rather than drudgeing thu SQL.

**cavedude** · #3 05-20-2005, 08:24 AM

Ahhh I see ease of use. In that case I'm sure some people could use it. I would post it up. There is never anything wrong with sharing work.

**WildcardX** · #4 05-24-2005, 05:52 AM

Not a bad idea... MySql Control Center isn't supported any longer and is not getting developed past what exists today, so Access isn't a bad idea I guess.

**Doodman** · #5 05-24-2005, 06:30 AM

Why not just install the mysql odbc drivers and then use the real database from access?

Seems a lot simpler to me.

http://dev.mysql.com/downloads/connector/odbc/3.51.html

solid11 · #6 05-24-2005, 06:53 AM

A little help on this one Doodman. So I installed the drivers, how do you access the DB? Just open up access and go to the data folder of mysql? Which didn't work for me. No files seem compatible.

I use mysql-front now, but I'm willing to try something new if it will help find certain fields faster. Any help on using this would be great. Just need to know the steps to access the DB from access. Thanks.

sdabbs65 · #7 05-25-2005, 05:01 AM

Quote:

Originally Posted by solid11

A little help on this one Doodman. So I installed the drivers, how do you access the DB? Just open up access and go to the data folder of mysql? Which didn't work for me. No files seem compatible.

I use mysql-front now, but I'm willing to try something new if it will help find certain fields faster. Any help on using this would be great. Just need to know the steps to access the DB from access. Thanks.

The way I do it is I have a converter that converts the files from SQL to a excel.mdb file and when im done....
change it back to a SQL file useing the same converter.