locked
How to create an index in VBA RRS feed

  • Question

  • In a procedure I will test if an index exist and in case no I will create this index. How can I do that?

    Thanks

    Friday, May 16, 2014 7:16 AM

All replies

  • VBA is the macro language for all office apps, so

    What application?
    What service pack level?

    Index in what, a database table? If so in Access, SQL Server? MySQL? or?? Please tell us more.


    Rod Gill
    Author of the one and only Project VBA Book
    www.project-systems.co.nz

    Friday, May 16, 2014 9:39 AM
  • Msaccess 2013 or also access97

    I have created a procedure with a recordset and I will test if an index already exist in this table and in case no I will create this index in the procedure.

    Friday, May 16, 2014 12:07 PM