Skip navigation links

MySQL Forums :: Microsoft Access :: Using Microsoft Access as a Front-end to MySQL


Advanced Search

Re: Using Microsoft Access as a Front-end to MySQL
Posted by: Brad Scott ()
Date: December 01, 2008 01:49PM

I’ve got my MySQL cgi application working great online. Now I’m trying to get to the data using MS Access 2000 as a frontend with the MySQL ODBC 5.1.5 Connector. All goes well with the linked tables, but before long, I get:



ODBC –call failed

[MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community]MySQL server has gone away (#2006)

The problem is the web host has a 15 second timeout. So, I want to connect, transfer data, and disconnect (without closing the database), then have the option to reconnect when needed. I've tried dropping all the linked tables and reconnecting them later, but I still get this message. The problem is clearly that Access is trying to maintain the connection even though there are no tables linked. Is there any way I can force Access to drop the connection when there are no tables linked (short of closing Access)?

thanks,

Brad Scott

Options: ReplyQuote


Subject Views Written By Posted
Using Microsoft Access as a Front-end to MySQL 63404 Edwin DeSouza 02/14/2007 01:10PM
Re: Using Microsoft Access as a Front-end to MySQL 16637 Robert Cass 07/08/2007 05:10PM
Re: Using Microsoft Access as a Front-end to MySQL 12720 Arpad Nev 08/24/2007 05:57AM
Re: Using Microsoft Access as a Front-end to MySQL 9390 wendy z 02/06/2008 01:16PM
Re: Using Microsoft Access as a Front-end to MySQL 5790 wasim hasan 09/01/2009 11:03AM
Re: Using Microsoft Access as a Front-end to MySQL 6071 Allen George 03/02/2009 06:09AM
Re: Using Microsoft Access as a Front-end to MySQL 6493 Brad Scott 12/01/2008 01:49PM
Re: Using Microsoft Access as a Front-end to MySQL 4696 Dave Schomburg 05/15/2009 08:45AM
Re: Using Microsoft Access as a Front-end to MySQL 4719 Dave Schomburg 05/25/2009 05:12PM
Re:solution - Using Microsoft Access as a Front-end to MySQL 4523 Dave Schomburg 05/26/2009 11:33AM
Re: Using Microsoft Access as a Front-end to MySQL 4955 Justin Medcraft 04/03/2009 02:44AM
Re: Using Microsoft Access as a Front-end to MySQL 4401 Stephen Hubbard 05/01/2009 08:36PM
Re: Using Microsoft Access as a Front-end to MySQL 4436 Stephen Hubbard 05/02/2009 04:37AM
Re: Using Microsoft Access as a Front-end to MySQL 4559 Steven Bebsen 06/08/2009 10:28AM
Re: Using Microsoft Access as a Front-end to MySQL 6060 NEIL BAILEY 06/09/2009 04:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.