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
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.
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!