[AccessD] Upgrade to MySql

  BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Yes.   Like I said, I would knock together a prototype and see what
works.  It took me less than an hour to download and install the
Community version of MySQL.  The current live version is 5.1.  The
development version is 5.5 and it seems to be pretty stable.
 Regards, 
 Steve Goodhall, MSCS, PMP 
 248-505-5204 
 On Fri 06/08/10 11:41 AM , "Rocky Smolin" rockysmolin at bchacc.com
sent:
 "Once you get a recordset"
 So that would be wherever I'm using Set rsMyRecordset =
db.OpenRecordset?
 Rocky
 -----Original Message-----
 From: accessd-bounces at databaseadvisors.com [1]
 [accessd-bounces at databaseadvisors.com [2]] On Behalf Of Steve
Goodhall
 Sent: Friday, August 06, 2010 8:36 AM
 To: Access Developers discussion and problem solving
 Subject: Re: [AccessD] Upgrade to MySql
   BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }I
don't
 think that you will need to change anything that will work through
ODBC.
 Once you get a recordset you should be OK for Move, Add, etc.  In
some cases
 you might want to rewrite things to be more efficient.  The biggest
problem
 you can expect is if you have a lot of Access generated forms that
work
 against complete tables or queries. 
 These are likely to lock too many rows on the server side.
  I would put together a small prototype to test the limits before
jumping
 into the conversion.
  Regards,
  Steve Goodhall, MSCS, PMP
  248-505-5204
  On Fri 06/08/10 11:15 AM , "Rocky Smolin" rockysmolin at bchacc.com
[3]
 sent:
  Steve:
  Thanks for the reply.  
  Yes it's an Access BE so all the communication from the front end
then must
 be done via ODBC, yes?  
  Do all the DAO methods - FindFirst, MoveFirst, .AddNew, .Esdit,
.Update,
 etc
  - need to be reprogrammed?
  TIA
  Rocky
  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com [4] [1]
 [accessd-bounces at databaseadvisors.com [5] [2]] On Behalf Of Steve
Goodhall
  Sent: Friday, August 06, 2010 7:35 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Upgrade to MySql
    BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Are you
 currently using an Access BE database or some other RDBMS?  I have
just
 started playing with MySQL but I have done several conversions to
MSSQL.
  You will need to set up an ODBC connection to the MySQL database
and link
 the tables.  There are probably some subtle difference in the SQL so
you may
 need to do a lot of testing.
   Regards,
   Steve Goodhall, MSCS, PMP
   248-505-5204
   On Fri 06/08/10 10:22 AM , "Rocky Smolin" rockysmolin at bchacc.com
[6] [3]
  sent:
   Deal List:
   I have a client with a rather large application who is considering
 upgrading  the back end to MySql.  
   Object:
   ~100 forms
   ~150 queries
   ~75 reports
   Lots of code modules with many lines and lots of CBF.
   The app uses bound forms and lots of DAO.  
   Question is, of course, what is involved in converting this front
end to
 work with a MySQL back end?
   MTIA,
   Rocky Smolin
   Beach Access Software
   858-259-4334
   www.e-z-mrp.com ;
   www.bchacc.com ;
   --
   AccessD mailing list
   AccessD at databaseadvisors.com [9] [6] [1]
   http://databaseadvisors.com/mailman/listinfo/accessd
   Website: http://www.databaseadvisors.com
  Links:
  ------
  [1] AccessD at databaseadvisors.com [10] [7]
  --
  AccessD mailing list
  AccessD at databaseadvisors.com [11] [8]
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
  --
  AccessD mailing list
  AccessD at databaseadvisors.com [12] [9]
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
 Links:
 ------
 [1] accessd-bounces at databaseadvisors.com [13]
 [2] accessd-bounces at databaseadvisors.com [14]
 [3] rockysmolin at bchacc.com [15]
 [4] http://www.e-z-mrp.com
 [5] http://www.bchacc.com
 [6] AccessD at databaseadvisors.com [16]
 [7] AccessD at databaseadvisors.com [17]
 [8] AccessD at databaseadvisors.com [18]
 [9] AccessD at databaseadvisors.com [19]
 --
 AccessD mailing list
 AccessD at databaseadvisors.com [20]
 http://databaseadvisors.com/mailman/listinfo/accessd
 Website: http://www.databaseadvisors.com
 -- 
 AccessD mailing list
 AccessD at databaseadvisors.com [21]
 http://databaseadvisors.com/mailman/listinfo/accessd
 Website: http://www.databaseadvisors.com
 

Links:
------
[1] mailto:accessd-bounces at databaseadvisors.com
[2] mailto:accessd-bounces at databaseadvisors.com
[3] mailto:rockysmolin at bchacc.com
[4] mailto:accessd-bounces at databaseadvisors.com
[5] mailto:accessd-bounces at databaseadvisors.com
[6] mailto:rockysmolin at bchacc.com
[7] http://www.e-z-mrp.com
[8] http://www.bchacc.com
[9] mailto:AccessD at databaseadvisors.com
[10] mailto:AccessD at databaseadvisors.com
[11] mailto:AccessD at databaseadvisors.com
[12] mailto:AccessD at databaseadvisors.com
[13] mailto:accessd-bounces at databaseadvisors.com
[14] mailto:accessd-bounces at databaseadvisors.com
[15] mailto:rockysmolin at bchacc.com
[16] mailto:AccessD at databaseadvisors.com
[17] mailto:AccessD at databaseadvisors.com
[18] mailto:AccessD at databaseadvisors.com
[19] mailto:AccessD at databaseadvisors.com
[20] mailto:AccessD at databaseadvisors.com
[21] mailto:AccessD at databaseadvisors.com