Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Find button on Sql Server linked tables

Status
Not open for further replies.

NeotheOne

IS-IT--Management
Jul 25, 2003
9
IT
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top