client side cursors for queries / forms

[princeshri]

Hi,

Im using Ms Access 97 with Linked tables to SQL Server.

I have a form that displays around a 1,000 records (probably more in the future) and it takes quite a while for updates and so on and Im guessing this is because the cursors are server side since the sql server cpu spikes up when this form is being viewed / updated.

Is it possible to use client side cursors either for the query that is called from the form or from the form and would that speed it up ?

Thanks for your help,



Shri

 

[cmmrfrds]

I am not sure about Access 97, but in Access 2000 you can use client side cursors with ADO. The library you need to reference is Microsoft ActiveX data objects 2.6. If you can reference this library then you should be able to use ADO. ADO is part of the MDAC installation which comes built in on the Windows 2000 OS, but can also be installed on WinXX OS's if not already available.

If you have the option to use Access 2000, this is the cleanest and easiest way to use SQL Server databases. The Access Project (adp) in Access 2000 allows you to make a connection to the database at the application level (ADO connection). This connection called the ActiveProject connection is available to use throughout your application. The connection uses the MDAC libraries and avoids the use of ODBC which is part of linking tables from SQL Server in an Access MDB.