Migrating db relationships from Access to MySQL
I currenty have a MS Access db app that I'm migrating to a MySQL back end while keeping the interface in Access (118 tables, 20k + entries). I've used the MySQL migration toolkit to get the data out of Access without any problems. However, I can't seem to get the relationships out of Access. If nothing else, I could manualy input them into MySQL, but I'd rather not do that if I don't have to. I've searched online, and coulden't find much. I followed some instructions for making the Access relationships table available to outside programs, but with no luck. Does anyone have any sugjestions?
|