MS Access front-end debugging

Job ID: 34138999

Budget: $30 – $250 USD

All details are in the following shared doc.
https://docs.google.com/document/d/1KEY2tRtTiOI7V6tklj0anEJQd2C8wjijbw9_ErmzPoU/edit?usp=sharing

Timeline:
ASAP

Budget:
Small project - ideal for seasoned MS Access and SQL developer


Task:
Debug our MS Access frontend which is locking a row on a specific table for specific users. We are unable to diagnosis why certain users get locked up and others dont. A previous verision of the form, which is available for comparison, does not suffer from the same issue.
The task is to compare the working and non-working frontend and determine what the issue is and apply a fix.

Needed:
Someone who can systematically debug and trace through MS Access frontend and MS SQL backend

Provided:
Previous version of working frontend
Current version on non-working frontend
Access to SQL (via shared connection)

Technology stack:
MA Access
MS SQL

Milestone
Identify issue in frontend that is locking the database for specific users
Make fix so that it stops happening
Related categories: SQL Microsoft Access Debugging