> > 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