Please help ME!!!
I've got a data entry form with Bridge details and a separate form which contains all the construction data for the bridge.
All data is stored in SQL server and the front end is in MS access.
Since moving the data to SQL when a new construction is added to a bridge the data in the construction table becomes locked and can only be edited from the SQL backend and not from MS access.
So the question that I hope you can answer is :-
Why does the single row get locked after its been saved and stay locked
And how can I stop this from happening?
I've got a data entry form with Bridge details and a separate form which contains all the construction data for the bridge.
All data is stored in SQL server and the front end is in MS access.
Since moving the data to SQL when a new construction is added to a bridge the data in the construction table becomes locked and can only be edited from the SQL backend and not from MS access.
So the question that I hope you can answer is :-
Why does the single row get locked after its been saved and stay locked
And how can I stop this from happening?
