Database Conversion.

[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

[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.

[sdabbs65]

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.

[solid11]

I don't suppose I can get my hands on this converter or explain how it's done could I?.....(beg,plead,grovel)

[sdabbs65]

Originally Posted by solid11

I don't suppose I can get my hands on this converter or explain how it's done could I?.....(beg,plead,grovel)

Well you could if you want to spend 40 bucks.
you can find it here.
http://www.softguru.net/products.htm

I will be releaseing the files on my website as one big database and
also each table seperately soon as im done revamping my board.
but im working on setting up a phpbb/nuke board atm so I have put this project on hold for a few weeks since it's not really needed.

[WildcardX]

This thread has motivated me to write a tool that will be a EQEmu Server database administrator. I am finishing up my first beta version and hope to have it released for download sometime this weekend. It is my intent to write this tool in such a way that it will not only be backward compatible to every previous world database, but will also adapt to future databases. In fact, the basic functionality of this tool will also work on pretty much any MySQL Server database versions 4.0.x, 4.1 or the future 5.0. After the beta release I will add tools to the application that are specific to EQEmu record keeping. The basic functions will present all databases in "Microsoft Access" like views and allow record updating, deleting or inserting. This tool is written in C#.NET so you will need to download the Microsoft .NET 1.1 Framework to use it.

I will make an announcement in the coming days, when this beta version is ready for downloading.

[Ghost Fire]

Very cool WildcardX. I'll download that