Setting the index for a table in another database 1

[zevw]

Sorry I am asking all these remote questions today.

here is the code for setting the index to a table in the current database.

DBEngine(0)(0).Execute "CREATE UNIQUE INDEX PrimaryKey ON RptBal (ID)"

How is it done, when its in another table?

 

[Remou]

Same idea.

[tt]Dim db As Database

Set db = OpenDatabase("C:\docs\ltd.mdb")
db.Execute "CREATE UNIQUE INDEX PrimaryKey ON New2 (ID)"[/tt]

 

[zevw]

Ah! So I learned something new.

I guess instead of DBEngine(0)(0).Execute I can do Currentdb.Execute when its in the current database.

Correct me if I am wrong.

 

[Remou]

Yes, you can.