RE: RE: Info Needed to Promote MySQL!!
as appealing for most people. One of the changes that I intend to make is to allow the code to be smart enough to determine whether the user has insert/update/delete permissions (verses just select) in which case, it will link them to the master copy instead of a slave for read only access. That process has also allowed me to work around a couple of other issues with ODBC that I do not care for. Another issue is that the user name is stored in the registry and the MS Access user name is not used. I have code in the startup routines that rewrite the registry keys to use the username of my choice (Currentuser()). The ODBC password is stored in plain text in the registry. The shortcomings there is obvious. So, I am rewriting the password as well. An interesting thing to note is that ODBC only reads the registry keys when relinking the tables, So I write the registry keys, delete the links, relink the tables, and then re-write the registry keys with bogus data. Anyone reading the registry keys won't recover the username and password. One other side note is the password that I use is not the password that the user gives me. I hash their password, and give the hash to MySQL as a password. That prevents the users from using anything but my application to access the tables. Most of the business logic for our application is in the front end. It would be unfortunate if someone was to side step that and edit the tables without any validation or referential integrity. I would be interested in this code you are talking about. I not sure I understand how exactly you are doing this. Are you doing VB/macros? To detect insert/update/delete would be the best route I would think, instead of always deleting the linked tables each time the database is loaded. What would happen if someone tries to modify the schema of table through M$ Access? Would it not screw things up or I assume at the least limit your control. -Original Message- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 6:08 PM To: venu; turner; mysql Cc: adouglas Subject: RE: RE: Info Needed to Promote MySQL!! As a quick note, I tried the same with MS SQL Server through its latest ODBC driver by adding the new column, and I couldn't see any changes in the linked tables from Access 2002. So it shows clearly that, its some thing related to MS Access, not with the driver. It might be a bug from Access or there might be some setting that we need to do it, inorder to see the changes to the table structure. So is this going to be looked into on how to resolve this issue or is it not fix able unless M$ does something? - 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. 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!!
What type of schema do mean here ? Because as you know, MySQL doesn't explicitly supports any schema's except the catalogs( in MySQL term 'database'). If you can elaborate what exactly the problem you are facing, then we can provide a rapid solution. Also, as for as I know, when I change something in my table in MySQL server side (including the table structure), it does reflect on the linked tables without any problems, and vice versa too. I have the following setup... - MySQL 3.22.32 on OpenBSD v2.9 - MyODBC on Windows '98 SE - MS Access 2000 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? Also if I may ask, is there any difference between MyODBC for Unix going to Windows to MyODBC for Windows going to Unix? I'm assuming that all the difference is the starting point but achieves the same tasks. - 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!!
I've had the same issues. I have really avoided the dev side of things for some time so I'm not sure whether there's a way around it. Mainly just devoting myself to administration. Funny though I'm starting to write jsp stuff to monitor the databases more effectively. I agree with you on the MYODBC from unix to windows and vice versa. Shouldn't be that different. Dave On Mon, Sep 24, 2001 at 03:09:50PM -0600, Adam Douglas wrote: What type of schema do mean here ? Because as you know, MySQL doesn't explicitly supports any schema's except the catalogs( in MySQL term 'database'). If you can elaborate what exactly the problem you are facing, then we can provide a rapid solution. Also, as for as I know, when I change something in my table in MySQL server side (including the table structure), it does reflect on the linked tables without any problems, and vice versa too. I have the following setup... - MySQL 3.22.32 on OpenBSD v2.9 - MyODBC on Windows '98 SE - MS Access 2000 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? Also if I may ask, is there any difference between MyODBC for Unix going to Windows to MyODBC for Windows going to Unix? I'm assuming that all the difference is the starting point but achieves the same tasks. - 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 - 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!!
Hi Douglas and David !! I have the following setup... - MySQL 3.22.32 on OpenBSD v2.9 - MyODBC on Windows '98 SE - MS Access 2000 Cool !!! 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 then you can see all the latest updated records of data in the linked table. 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 ? Also if I may ask, is there any difference between MyODBC for Unix going to Windows to MyODBC for Windows going to Unix? I'm assuming that all the difference is the starting point but achieves the same tasks. No difference. 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 - 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!!
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!!
Hi !! As a quick note, I tried the same with MS SQL Server through its latest ODBC driver by adding the new column, and I couldn't see any changes in the linked tables from Access 2002. So it shows clearly that, its some thing related to MS Access, not with the driver. It might be a bug from Access or there might be some setting that we need to do it, inorder to see the changes to the table structure. 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: David Turner [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:43 PM To: Venu Cc: Adam Douglas; Mysql@Lists. Mysql. Com (E-mail); David Turner Subject: Re: RE: Info Needed to Promote MySQL!! I was never able to see the changes in table structure with Access and Oracle unless I manually added the column to linked table in Access after I had added it in Oracle. Dave On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote: Hi Douglas and David !! I have the following setup... - MySQL 3.22.32 on OpenBSD v2.9 - MyODBC on Windows '98 SE - MS Access 2000 Cool !!! 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 then you can see all the latest updated records of data in the linked table. 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 ? Also if I may ask, is there any difference between MyODBC for Unix going to Windows to MyODBC for Windows going to Unix? I'm assuming that all the difference is the starting point but achieves the same tasks. No difference. 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 - 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 - 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 - 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!!
As a quick note, I tried the same with MS SQL Server through its latest ODBC driver by adding the new column, and I couldn't see any changes in the linked tables from Access 2002. So it shows clearly that, its some thing related to MS Access, not with the driver. It might be a bug from Access or there might be some setting that we need to do it, inorder to see the changes to the table structure. So is this going to be looked into on how to resolve this issue or is it not fix able unless M$ does something? - 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