I was made to believe that the 10 second slowness experienced in MS Access data entry was coming from within access not from the SQL server. The correct status is not from MS Access forms, its actually from the SQL Server itself.
I have experimented manually by going directly to capture data in the sample table as per screen shoot below, the movement of the cursor from one field to the other ties up with MS access form, in short the speed is the same.
Problem area
The cursor to create a NEW line takes 10 second in SQL SERVER, this is exactly what I'm experiencing at MS Access forms level, is there another procedure to be done at MS SQL SERVER to improve the speed here? This is the correct position properly verified not assumptions.
I have experimented manually by going directly to capture data in the sample table as per screen shoot below, the movement of the cursor from one field to the other ties up with MS access form, in short the speed is the same.
Problem area
The cursor to create a NEW line takes 10 second in SQL SERVER, this is exactly what I'm experiencing at MS Access forms level, is there another procedure to be done at MS SQL SERVER to improve the speed here? This is the correct position properly verified not assumptions.