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