Link to home
Start Free TrialLog in
Avatar of bswg3549
bswg3549Flag for United States of America

asked on

Read/write conflicts after upgrading to solid state drive

A bit of a weird one here;   I recently updated on computer to a solid state drive that is about 30 times faster for read/write than a traditional HDD.  This PC both holds an MS Access back end as well as runs the front end that connects to the tables in the back end.   We have many other computers on the network that connect to the back end.  All computers till run MS access front end with no issues.  but, the computer that actually contains the back end on its SDD gets constant read/write conflicts since the upgrade to the faster drive.   Anyone experience this?  Is it possible the hardware is now to fast for MS ACCESS to handle.  It seems the tables are being written before the form can understand that it asked for the save?
I hate to go back to the standard HDD just because the new drive is too good for an old timer like ACCESS to use.  I am on latest version of OFFICE/MS Access.    Any insight on reducing or eliminating these read/write conflicts is greatly appreciated!
Avatar of PatHartman
PatHartman
Flag of United States of America image

Are you saying that you have a peer to peer network and the node that holds the BE is also a workstation that runs the FE?
maybe the locking is set to pessimistic in Access Options?
Avatar of bswg3549

ASKER

Yes - the network has a single work station with the BE, the workstation that holds the BE also has front end installed.      I will check out the locking mentioned by Jonathan - thanks!
I did not find anything regarding "pessimistic locking" for my set up, but I have attached the options for both be and fe file locking.  I assume since shared and no locks are selected that this is optimistic?
fe_locking.PNG
be_locking.PNG
looks good.

what is the error message you get when the conflict happens?
most consistent is attached.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.