If you have your native, auto-updated table in MS Access and a different Linked table pointing to the MySQL copy of it in the same database, just build an Access query that will INSERT or UPDATE (as appropriate) your linked table with data from your native table. No scripting required, just the internal data manipulation of Access.
Consult the MS Access help files or any number of online resources for instructions on how to build a query in access that copies data from one table to another. Shawn Green Database Administrator Unimin Corporation - Spruce Pine nephish <[EMAIL PROTECTED]> wrote on 07/13/2005 10:32:19 PM: > you mean like in a script? > the windows computer runs access, which i am not very familiar with > and was able to accomplish what i have done so far by lots o' docs at > the mysql.com site. > > sorry for the newbie-ness of this question. i am somewhat familliar with > python, maybe there is a module i can use for this.. > thanks, > > On Wed, 2005-07-13 at 22:10 -0500, mos wrote: > > At 08:51 PM 7/13/2005, you wrote: > > >Hey there, > > >thanks to some help i have received right here, i have been able to > > >access a mysql database on a linux computer from MS access on a windows > > >computer, i was able to connect and create the tables and export all > > >rows correctly.. i used MyODBC from mysql. > > >ok, here is the deal, the access database gets info from another > > >program and adds new rows every 15 seconds or so, i need some automated > > >way to sync the two databases together every oh,,, 5 minutes or so. > > >there is lots of documentation on how to do this by linking a table to a > > >mysql table, however, when i do this, the access table is the one that > > >gets updated, not the mysql table (deletes any info received since last > > >update) and still does not provide a way to do this automatically. I > > >cant find way to do it anywhere, little or no docs.. or i am looking in > > >the wrong place. > > > > > >thanks for reading this, hope someone can help > > ><>< > > > > Have you tried prefixing the MySQL table with the MySQL database name? > > Example: > > > > select * from MySqlDb1.Table1; > > insert into MySqlDb1.Table1 (cust_id, cust_name) values(1,"John Smith"); > > > > Mike > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
