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