Database Conversion.

[sdabbs65]

Greetings,
I have the ability to convert MYSQL Databse files to MSACESS 2000.mdb format.
I was wondering if this would be usefull and if anyone is interested in
something like this before I go forward and create a files area for it.
basicly what I plan on doing is taking each field and making a mdb file for it.
for example.

items text.sql would be converted to items.mdb
you could then add whatever or modify it in a reader friendly format.
then I can convert it back when im done to a SQL format.
I have done a few fields already and it seems to be a good idea.
here is a few screenshots of what it looks like to give you an idea.

---edit this is for microsoft access 2003----

[cavedude]

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]

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]

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]

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]

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