Hi. This is my first time posting so Im not too sure if the topic is up already. Apologies if is.
Anyway. My problem is that have mySQL running on a windows 2k machine. I also have the latest connection driver and also the latest query analyser, migration tool. What I am trying to do is connect to an external database. At present I connect up to it through Access. What I first tried to do was migrate the database but the tables are too large and I maxed out the connection. Secondly I tried to link to the tables through access but I cant do this as the tables are already linked in access and it doesnt allow for double linking. I then tried to import the tables to access but again they are too big and i maxed out the line. Lastly i tried to import the files to mysql. again maxed the line. What im essentially trying to do is to link to these tables directly from mySQL thus avoiding access. How is this done as i have been trying with the connector and it hasnt work. Also I have scoured the mySQL website and cant find the right solution. I pretty sure it can be done I just dont know how. Thanks again.