RE: RE: Info Needed to Promote MySQL!! - Solved
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. How is the speed of running Queries, Forms and Reports from Access using linked tables to MySQL? I've found it quite slow. Tasks that use to take a few seconds now takes 3 minutes or more. On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote: Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. All I can say is, Wow! Excellent response! Thanks! So, this solves all your problems. Let me know whether it helps you or not. Looks like it works great but how about this (smile).. Is there a way to have this update done on linked tables automatically and is it possible to have this done on a global scale. Meaning that the linked tables would work on all machines not a specific machine? Would having a general ODBC username/password setup on multiple machines resolve the problem? Sorry meant to ask this question before. - 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
RE: RE: Info Needed to Promote MySQL!! - Solved
Hi Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. Microsoft Access confirms a successful refresh or, if the table wasn't found, displays the Select New Location of table name dialog box in which you can specify the table's new location. If several selected tables have moved to the new location that you specify, the Linked Table Manager searches that location for all selected tables, and updates all links in one step. So, this solves all your problems. Let me know whether it helps you or not. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:43 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: RE: Info Needed to Promote MySQL!! Now I've found when I do changes to a table schema the changes are not entirely at least reflected in a the same table linked in Access. I had once case where I changed a data type on one of the columns and that data type was not changed on the linked table in Access. I had to remove the link and then recreate it. The table type I'm using is MyISAM. From my experience with MyODBC it seems that it's not a live link correct? This problem has occurred on three machines including mine. Do I have something setup wrong then? Is there anything else that you need to know? Ok. I tried now, and even for me the latest table strcuture is not visible in the linked tables. I am using Access 2002. But I can see the inserted/deleted rows of data in the linked table after I do the refresh from records menu. If it doesn't work, you need to use filters from record menu as follows: - Refresh - Apply filter / sort - Remove filter / sort I can see inserted/deleted rows as well it's just the schema issue that bothers me and was wondering if this was normal. I will crosss check with the MyODBC code and Access calls, why it is not able to display the latest changes to the table structure, and if I find something, let you know. Also, what about other vendors ? Does Access displays the changed table structure in linked tables ? That would be great, thanks! - 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
Re: RE: Info Needed to Promote MySQL!! - Solved
On Mon, Sep 24, 2001 at 03:02:42PM -0700, Venu wrote: Hi Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. Microsoft Access confirms a successful refresh or, if the table wasn't found, displays the Select New Location of table name dialog box in which you can specify the table's new location. If several selected tables have moved to the new location that you specify, the Linked Table Manager searches that location for all selected tables, and updates all links in one step. So, this solves all your problems. Let me know whether it helps you or not. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:43 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: RE: Info Needed to Promote MySQL!! Now I've found when I do changes to a table schema the changes are not entirely at least reflected in a the same table linked in Access. I had once case where I changed a data type on one of the columns and that data type was not changed on the linked table in Access. I had to remove the link and then recreate it. The table type I'm using is MyISAM. From my experience with MyODBC it seems that it's not a live link correct? This problem has occurred on three machines including mine. Do I have something setup wrong then? Is there anything else that you need to know? Ok. I tried now, and even for me the latest table strcuture is not visible in the linked tables. I am using Access 2002. But I can see the inserted/deleted rows of data in the linked table after I do the refresh from records menu. If it doesn't work, you need to use filters from record menu as follows: - Refresh - Apply filter / sort - Remove filter / sort I can see inserted/deleted rows as well it's just the schema issue that bothers me and was wondering if this was normal. I will crosss check with the MyODBC code and Access calls, why it is not able to display the latest changes to the table structure, and if I find something, let you know. Also, what about other vendors ? Does Access displays the changed table structure in linked tables ? That would be great, thanks! - 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
RE: RE: Info Needed to Promote MySQL!! - Solved
Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. All I can say is, Wow! Excellent response! Thanks! So, this solves all your problems. Let me know whether it helps you or not. Looks like it works great but how about this (smile).. Is there a way to have this update done on linked tables automatically and is it possible to have this done on a global scale. Meaning that the linked tables would work on all machines not a specific machine? Would having a general ODBC username/password setup on multiple machines resolve the problem? Sorry meant to ask this question before. - 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
RE: RE: Info Needed to Promote MySQL!! - Solved
Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. All I can say is, Wow! Excellent response! Thanks! So, this solves all your problems. Let me know whether it helps you or not. Looks like it works great but how about this (smile).. Is there a way to have this update done on linked tables automatically and is it possible to have this done on a global scale. Meaning that the linked tables would work on all machines not a specific machine? Would having a general ODBC username/password setup on multiple machines resolve the problem? Sorry meant to ask this question before. - 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
Re: RE: Info Needed to Promote MySQL!! - Solved
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. Dave On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote: Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. All I can say is, Wow! Excellent response! Thanks! So, this solves all your problems. Let me know whether it helps you or not. Looks like it works great but how about this (smile).. Is there a way to have this update done on linked tables automatically and is it possible to have this done on a global scale. Meaning that the linked tables would work on all machines not a specific machine? Would having a general ODBC username/password setup on multiple machines resolve the problem? Sorry meant to ask this question before. - 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