[AccessD] How to Delete or modify an index in VBA

Ya' know. I've often though about the BEU and John C's stuff, but I have
built so many functions in my Framework to do most of the features, I
decided not to. I never had to change indexes before (because my designs are
always so perfect!) :)   So, index handling wasn't in my frame work.

Some day (in all my free time), I'll look at the BEU and others but not in
the near future.

Thanks!!!

John



-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Wednesday, March 12, 2003 3:30 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] How to Delete or modify an index in VBA


John
Just the kind of thing the BEU (Backend Upgrader) will do for you.
(couldn't resist the plug)

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of John Skolits
> Sent: 12 March 2003 18:44
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] How to Delete or modify an index in VBA
>
>
> Anyone know how to delete an index in VBA after it's already
> been added to a collection. Another option would be to modify
> it (add a field) or to set it's Unique property to false. Any
> of these would be fine.
>
> I know how to Create an index, just can't delete it. I am
> using DAO but could also use ADO if that's the better solution.
>
>
> John Skolits
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website:
> http://www.databaseadvisors.com
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com