[AccessD] How to Change "Max Locks Per File" with VBA code - Access 2007 - ADO

We have an existing Access 2007 application that uses ADO.

We want to temporarily change the "Max Locks Per File" with VBA code.

I have found some examples on how to do this, but I keep running into
problems.

Does anyone have a simple example?

Thanks,
Brad