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
