On Mon, Sep 24, 2001 at 03:02:42PM -0700, Venu wrote:
> 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
