Link MySQL tables on Access tables

[Oh_JaE]

😀 hi there everyone!

i'm really going nuts on finding this thing about linking the MySQL table to an Access table.

anybody who knows how?

please…. your help would be very much appreciated! Thanks!

[Ritesh]

I am not sure whether I understood your problem correctly.

QUOTE

i'm really going nuts on finding this thing about linking the MySQL table to an Access table.

Do you mean using Access to work with MySQL?

[Oh_JaE]

hi ritesh,

my problem is that i can't link the access tables into mysql.

i can link the mysql tables into access from >File>Get External Data>Link Tables, but the other way around, i can't! and that's what i really need – to have linked tables in mysql wherein the data of these tables are coming from the access tables.

that's it. i hope u got what i'm saying. thanks in advance for any help/advice you could give.

[Ritesh]

QUOTE

can link the mysql tables into access from >File>Get External Data>Link Tables, but the other way around, i can't!

You cannot do that in MySQL.

[nero]

Access is a application using data sources

It's main datasource is a .mdb file accessed viaa the jet engine.

You are telling Access to use a .mdb and in that mdb are also the forms storage.

If you are linking a MySQL table the you tell the Access apllication to use an extra datasource

and this one is accessed via ODBC to MySQL server.

If you need some (access) database you need access to a provider to the mdb as datasource. Access using the Jet engine. You can use a ODBC link, ADO or OLEDB dependen on the platform you are working on but you must do it in your application.

If you need a link between the tabels you must write your self a intreface to a user recordset wich handels the link dependency.

So it can be done but it is'nt alway so simple as using Access as shell application.

Hope this will help you.

[Author]

Posts