Access - SQLServer2000

[rann]

HI,
I have a application which has Access as Front end and SQLServer as BackEnd.
I have a table which has student details.

Table Fields are:
Record#,FirstName,LastName,MiddleName,Address,City,State,Pin,.....
The table has about 1200 records.

Every Thing works fine but in the front end when i try to do a search by
FirstName it is VERY SLOW.I need to use ctr-break to stop the process or it keeps going on.But it is okey if i search by the Record#.I need to search by lastname or Firstname and speed up the process.I even tried creating a FullTextIndex but it was of no use.


Any Help will be appreciated,
Thanks in advance,
Rann.

 

[tlbroadbent]

How are you searching? With a query? Find?

Does the SQL Server table have an index on FirstName and/or LastName? Does it have indexes on other columns that may be used for searching? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rann]

Hi,
I am seaching using Find(The option available in Access).
i have just one index Record#.when i search record# it
is fast. but the problem is with lastname and firstname.
I think i need to create a index for lastname and firstname.

Do you have any more suggestions.
I will appreciate any help,

Thanks for you Help,
Rann.

 

[tlbroadbent]

Indexing is very critical in SQL Server. You can create multiple indexes so create an index on First Name and and index on Last Name and on any other column that users will search. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jorgen2]

Indexes are your key. Find uses indexes as all searching does, and as such indexes will need to be set up on any fields your users may search on.