Can Somebody please help<br><br>I have an access form linked to a table in a microsoft SQL Server database. I want to perform a search on one field in this table through a button on the form and the field must be indexed for the search to occur efficiently. The problem is that through Access I can't reset the index property of the field to "yes" in the linked tables design view after linking the table as Access doesn't allow you to change properties of a linked table. I've tried indexing the field through the SQL Server enterprise Manager but when I link the table to the access form and view the index property for that field it is set to "No" index.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking an access form to a table in a MS SQL Server database
- Thread starter FROGGER
- Start date
Similar threads
- Locked
- Question
- Locked
- Question