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]
