I have moved all the tables to SQL Server using upsizing wizard.
However now users experience big problems, the database hangs.
I did some research and I have noticed that:
1) There is a blocking process
2) The blocking process SQL is:
"SELECT "dbo"."Contacts"."ContactID" FROM "dbo"."Contacts"
3) The SQL above is executed when the user opens "Contacts" form. The Contacts form returns all records...
4) The locking is set to "Edited Record Only"
Please help. My client is extemely unhappy...
However now users experience big problems, the database hangs.
I did some research and I have noticed that:
1) There is a blocking process
2) The blocking process SQL is:
"SELECT "dbo"."Contacts"."ContactID" FROM "dbo"."Contacts"
3) The SQL above is executed when the user opens "Contacts" form. The Contacts form returns all records...
4) The locking is set to "Edited Record Only"
Please help. My client is extemely unhappy...