troubleshooting Question

MySQL / Microsoft Access - write conflicts making me crazy!

Avatar of Eileen Murphy
Eileen MurphyFlag for United States of America asked on
Microsoft DevelopmentMicrosoft AccessMySQL Server
5 Comments2 Solutions482 ViewsLast Modified:
Hello experts. I have recently migrated an Access back-end database to MySQL. I have an Access form that has a lot of subforms.

Example:

Main Form contains Job information

Subform A contains Skids/Rolls - initially opens to show ALL skids/rolls for a job

If main form field 2-up = true  - Subform B is then visible - filtered by a field if it contains "B" and Subform A is changed to be filtered by a field if it contains "A".

So the recordsource of these 2 subforms do change when the main form opens after the 2-up field value is determined -- or if the 2-up field is changed.

There are 2 more subforms that summarize data from the Skids/Rolls table but all recordset types are set to snapshot

<b>So here is my problem - no matter what field is updated on the main form, I get: </b> <i> "Another user edited this record and saved the changes before you attempted to save the changes"</i>

I have added timestamp fields to all tables and attempt to force saves to prevent these issues -- nothing I do seems to be helping.

Any/All suggestions will be appreciated.

Thanks a lot!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros