> What I did to handle global changes was have one access file on the
> fileserver that everyone had a shortcut to. That way the updates
> were global since they were all to the same file.
How is the speed of running Queries, Forms and Reports from Access using
linked tables to MySQL? I've found it quite slow. Tasks that use to take a
few seconds now takes 3 minutes or more.
> On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote:
> > > 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.
> >
> > All I can say is, Wow! Excellent response! Thanks!
> >
> > > So, this solves all your problems. Let me know whether it
> > > helps you or not.
> >
> > Looks like it works great but how about this (smile)..
> >
> > Is there a way to have this update done on linked tables
> automatically and
> > is it possible to have this done on a global scale. Meaning
> that the linked
> > tables would work on all machines not a specific machine?
> Would having a
> > general ODBC username/password setup on multiple machines
> resolve the
> > problem? Sorry meant to ask this question before.
>
---------------------------------------------------------------------
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
