Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Access and MySQL

    I have an access DB with MySQL tables linked through ODBC Connector 3.51.
    My forms work good, but if i stay some minutes without making select, insert or update in the form, the form don't work anymore, giving error on every event you start. For example, clicking on close buttom i receive the message "comando non disponibile on questo momento" (command non available at the moment).
    Is a timeout problem ?
    Thank you in advance

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: Access and MySQL

    Are you using a connection object? Make sure that it has not gone out of scope or you have not set it to Nothing. A connection can remain open (consuming resources) but unless you explicitly close it (or it goes out scope) it should remain open and your queries, updates etc... should continue working.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •