NEED HELP PLEASE (INDEXING)

W

wbowers

I have a linked table called tbl_students and I want to
remove all indexes and/or primary keys. Access 97 gives
me a message stating that I cannot remove indexes/primary
keys for a linked table.

Is there a way around this? I need to do this
programmatically?


PLEASE HELP
 
A

Allen Browne

If you OpenDatabase() directly on the back end file, you can Delete from the
Indexes collection of the TableDef.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
Problem with disappearing index in a table 1
Duplicate the record in form and subform 23
Access 2007 Compact and Repair 0
Application project in the database is corupt! 4
how to append index key to the field in access 1
Not able to enter Chinese 4 byte characters (GB18030)in MS Access 0
Need Help with Macro Security 1

Top