Converting an Access app from Jet database to MySql ... Anyone have experience with converting an access app from Jet database to Mysql? ... I understand there are some data format differences in text field types and date types that need to be addressed if converting from Jet to Mysql.... (comp.databases.ms-access)
Re: ADO connection Open failure ...DAO is needed for schema data manipulating, I'd also use DAO for data ... DAO is better than ADO when dealing with JET database.... (microsoft.public.excel.programming)
Re: ADO connection Open failure ... Since you use DAO, have you tried to use DAO to open the database/a RecordSet? ... If the code is to only work with JET database and since DAO is needed for schema data manipulating, I'd also use DAO for data accessing. ... DAO is better than ADO when dealing with JET database. ... > - Microsoft Office 11.0 Object Library ... (microsoft.public.excel.programming)
Re: Access View ... > I finally found a conversation where someone said, Access uses DAO,... > Help file said "Note The Microsoft Jet database engine does not ... (which is actually a saved query in disguise). ... (microsoft.public.inetserver.asp.db)
Re: Need help with a DAO to ADO conversion ... As I posted earlier to Chuck Grimsby in the "Query Too Soon?" ... I can eliminate the DAO question completely and perhaps get ... If the BE's a Jet database, then it's not ODBC: you can't use ODBC to link ... (microsoft.public.access.formscoding)
