Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing - I'm just not getting it
Message
From
30/12/1999 18:16:19
Jay Shepherd
Construction DataFax, Inc.
Montevallo, Alabama, United States
 
 
To
30/12/1999 06:58:57
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00310169
Message ID:
00310736
Views:
20
> strdbname = "c:\bardice3\hiscore.mdb"
> strrsname = "hiscore"
> Set db = DBEngine.OpenDatabase(strdbname)

> Set tdfHiScore = db!hiscore

> Set rs = db.OpenRecordset(strrsname, dbOpenTable)

> Set idxScore = tdfHiScore.Indexes("ScoreIndex")
> tdfHiScore.Indexes.Refresh

Ok, yes you are using DAO (the DBEngine gave it away)

I think what you need to do (and it's been a LONG time since I've used DAO), is open the database, then open a open a recordset with the table name, and then set the index on the recordset.

I do not know the syntax for this off the top of my head, but if you need it I could figure it out.
Jay Shepherd
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform