Access syncronization among several users (1 Viewer)

[jcsuarez]

I work with ACCESS 2003. I save all my files in ACCESS 2000 format. I´m working with several people using ACCESS 2010, and find it awfully annoying to try to synchronize data among the different users. It always sends a message of "Too many Locks per File". I increased the Locks per file with a procedure I was sent from this Forum, but it still keeps sending the same message. This is not the only message I get, so my question is: Is there any way to simplify this process of synchronization? My users share only data, because designs are kept original in every computer. Help me, please

 

[Uncle Gizmo]

Look up front-end back-end arrangement...

 

[arnelgp]

have you try setting it in code:

DbEngine.SetOption dbMaxLocksPerFile, 500000

you should also release the lock as:

DbEngine.Idle dbFreeLocks

 

[jcsuarez]

Thank you, Arnelgp. I´ll try it and let you know how it worked