Hi,
I'm porting an Access application composed by a file containing forms, report, ecc. and a file containing data from Access to Sql Server.
I've loaded all the data in Sql Server and relinked the table to them. All existing indexes has been created too.
Now, accessing forms on Access I can see data on Sql Server.
Everything seems to work correctly except for the button Find on datasheets.
I've terrible performances on that function, something about 20 times the same operation on Access before the porting.
I know Find is a client-side operation, but someone can explain to me the matter of such a downgrade of performances ?
Ms Access version is 2002 and Sql Server 2000
Thanks
Achille
I'm porting an Access application composed by a file containing forms, report, ecc. and a file containing data from Access to Sql Server.
I've loaded all the data in Sql Server and relinked the table to them. All existing indexes has been created too.
Now, accessing forms on Access I can see data on Sql Server.
Everything seems to work correctly except for the button Find on datasheets.
I've terrible performances on that function, something about 20 times the same operation on Access before the porting.
I know Find is a client-side operation, but someone can explain to me the matter of such a downgrade of performances ?
Ms Access version is 2002 and Sql Server 2000
Thanks
Achille