"Bing Du" <[EMAIL PROTECTED]> wrote on 04/04/2006 12:20:23 PM:
> Hello everyone, > > Please correct me if my understanding is wrong. Does the implementation > of linked table mentioned on "18.1.11.3. How to Import or Link MySQL > Database Tables to Access?" > (http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that > data is actually stored in MySQL and tables in Access are links pointing > to tables in MySQL? > > What I want is do linked table the other way, which is store data in > Access and make tables in MySQL links that point to tables in Access? Is > it possible and how? > > Thanks in advance, > > Bing > The only way to link tables in MySQL (to use the term from Access) is to use the Federated database engine. A Federated table physically exists on one server but virtually exists on another. This is exactly like creating a linked table. However, AFAIK, the Federated database engine only supports direct MySQL to MySQL sharing. It is not ready to do MySQL to <any other server> yet. http://dev.mysql.com/doc/refman/5.0/en/federated-description.html http://dev.mysql.com/doc/refman/5.0/en/federated-limitations.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
