msaccess to mysql with myodbc

[tjv]

I'm using MS Access W/ MyODBC OS is WIN 2K (uptodate) and MySql on RedHat 7.3

MS Access opens the database just fine and the linked table & query linked forms work GREAT however if the database stays open for a as yet unnown length of time the following happens.

I have command buttons that are in the main form that are linked to queries that open additional forms. When you click on on of these command buttons the follwing message popsup. " you man not run this command at this time" (or something real close to that. and then if I try to close the database I get an error indicating that I will be breaking the code do I wish to procede I click "OK" but nothing happens and i need to kill the application with Ctrl Alt Del end task.

 

[hvass]

Sorry I dont have an answer for you but have started to have the same problem when updating from mysqlfront 2.3 to mysqlfront 2.5 a windows app
My guess is that this is an ODBC / ADO / Windows / Microsoft message so I don't hold out much hope of resolving it on this forum and have simply added it to my Microsoft list of unresolved mysteries
I thank god and you all for open source and the GNU General Public License

 

[ctskinne]

Seems like ADO is not supported by mySQL
I have VS6 C++ ADO mySQL myODBC
and recordset->Update() SOMETIMES fails when repeated, not always
other ADO commands like MoveLast are _rumoured_ to fail
I am just on day 3 of conversion from Access97 to mySQL
and I dont want to rewrite all my ADO code
[I know the C++ "variant" syntax is grotesque, but I've
got it working with Access97 and would love to switch to a real DB with just a connection string change...]
-----This is the ADO error
Code = 80040e38 Hex WCode = 3128 Decimal Meaning = IDispatch error #3128 Source = Microsoft Cursor Engine Description = Row cannot be located for updating. Some values may have been changed since it was last read.
-------------------


cts