Finally I solved the problem myself. I add only connection.CursorLocation = adUseClient then all of my problems solved. Thanks for all replay
I want to explaint that all functions from server side working fine, but when I try same query from client side some functions are working such as...
Sorry Mr. Adriaan, By mistake I type it wrong original text is: Select * from HR_Tsalary where month='3' and year ='2010': The result is same from...
When I try with following command working fine SELECT * FROM HR_Tsalary where month='3' and year =’10’ : Result is 473 records and I found that...
Please find herewith code,which I use under the command butter to make query:Dim cnn As ADODB.ConnectionDim rst As ADODB.RecordsetDim strquery...
I have payroll record of more than 500 employees for one year in the database, I want to find only duplicate entry in a month; For example: I want to...
Recently our database is transferred to SQL server and I am a beginner with Sql server, I use following query in Access working well but in Sql...
Please help me to create a query to check no duplicate data created for any employee(s) in the same month in Payroll Database with following fields...
Separate names with a comma.
