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