Linked Tables Quicky

[hedidit]

Can i link table into a mySQL databse like i can with Access so that the table shows in MySQL but is stored elsewhere / in a different database?Cheers

 

[dunamin]

I've never seen this done. Were you going to try to link an Access table?

The function of linking external data is usually done in the programming language. Microsoft Access has Visual Basic built into it, however mysql is not a programming language by most standards. If you want to use different databases in the same application, try using ODBC for your final programming language (Java, PHP, etc).

 

[sleipnir214]

hedidit:
Are you asking about tables in an Access database that are actually links to a MySQL database?

Sure, you can do that. Install MyODBC on your system so that you can have ODBC access to MySQL. Then link the tables as you would to MS SQL.

I recommend strongly that you look at pass-through queries (look that up in Access's help system) when you are manipulating these tables. You'll get better performance.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[hedidit]

dunamin thats exactly what I was after... i have a huge database in MS Access that I don't have time to fully convert to MySQL (it uses ASP etc) however there's one part i would like to convert but i need to shre some tables between Access and MySQL... i know access can lnik to MySQL tables but it'd be easier the other way around...

Maybe i shouldn't be sooo lazy and just convert the whole thing!