Re: Using Microsoft Access as a Front-end to MySQL
I haven't had a lot of problems when the application side has just been updating the data through the forms. You can get warnings/errors when the same row has been updated by more than one user; but Access seems to be constantly updating its live record sets all the time.
Problems can happen if Alice is already working with record 365, and the Bob updates it, and then Alice tries to update it with her changes. As I recall, Alice will get a cryptic error message. It would be easier for the users if you trap these errors and at least give them a friendlier error message.
I've had more problems when I was editing records in the VB code through RecordSets, especially when combined with editing the same data on forms. That's not necessarily a multi user problem; however, you have almost the same situation because you have one user with multiple connections to the same data.
Love Is Life
Subject
Views
Written By
Posted
71521
February 14, 2007 01:10PM
18554
July 08, 2007 05:10PM
14296
August 24, 2007 05:57AM
11023
February 06, 2008 01:16PM
7201
September 01, 2009 11:03AM
Re: Using Microsoft Access as a Front-end to MySQL
7406
March 02, 2009 06:09AM
8099
December 01, 2008 01:49PM
5938
May 15, 2009 08:45AM
6131
May 25, 2009 05:12PM
5998
May 26, 2009 11:33AM
6317
April 03, 2009 02:44AM
5700
May 01, 2009 08:36PM
5720
May 02, 2009 04:37AM
5962
June 08, 2009 10:28AM
7457
June 09, 2009 04:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.