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]