This depends on whether the table will always be open I believe you are using MyODBC connection. Create a new table and then choose link table in access. While linking choose to save the password. Any changes which will occur in the mysql table will be viewable from access. But this will occur when the table is reopened. If the table is already open the record changes will not be viewable.
----- Original Message ----- From: "Kittiphum Worachat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 3:54 PM Subject: Autorefresh MyODBC > Hi. > > Can we use Access to link table in MySQL and force Access to refresh data > from MySQL automatically when data in MySQL table have change. > > Kittiphum Worachat,M.T. > www.hatyailab.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ____________________________________________________________________ - This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error you may not disclose, copy, distribute or act upon its contents without the authors prior written consent. Please can you notify the system manager at [EMAIL PROTECTED] immediately and delete this email. - Any views or opinions expressed are those of the author and do not necessarily represent those of Somak Travel Limited, Kenya. - This footnote also confirms that this email message has been swept for the presence of computer viruses. No responsibility can be accepted in the event that a virus is contained within it or any attachments. - SOMAK TRAVEL LTD - KENYA NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175 MOMBASA, PO BOX 90738. Tel: +(25411)486197 Fax:+(25411)487324 ____________________________________________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php