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!

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

SQL - Index access

Status
Not open for further replies.
9695

9695

Programmer
Nov 17, 2000
2
PT
How can I use an Index with SQL Data Base Access?

cnmSQLServer.Provider = "sqloledb"
cnmSQLServer.Open "driver={SQLSERVER};Server=Server; Database=Aiccopn2;"

rstBancos.Index = "Descricao"
rstBancos.Open "Bancos", cnmSQLServer, adOpenKeyset, adLockOptimistic, adCmdTableDirect

rstBancos.seek txtDescricao

He keeps telling me that there isn’t any Index weed that name ?? But there is... What is wrong ?
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
656
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
290
strongm
strongm
sal21
  • Locked
  • Question
How can i get the Column Index and the Row Index when I click on the ListView? 1
Replies
3
Views
316
sal21
sal21
2009luca
  • Locked
  • Question
Find exact valute in listview and return the row index
Replies
3
Views
196
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
295
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top