Heenan, Lambert
Lambert.Heenan at AIG.com
Tue Jan 13 10:13:15 CST 2004
Have you tried opening the table in question and removing the Index setting from the offending field. Then save the table design. Next reinstate the index and save the table design again. With a bit of luck Access will simply rebuild the index and all will be well. Lambert -----Original Message----- From: Mark A Matte [mailto:markamatte at hotmail.com] Sent: Tuesday, January 13, 2004 10:50 AM To: accessd at databaseadvisors.com Subject: [AccessD] DESPERATE problem with indexes Hello All, In A97 I have a db giving the error "<Index name> isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names. (Error 3015)"...I get the error when trying to link to ,import from ,compact or repair this db...I desperately need to get the data out of the db...any ideas? Thanks, Mark A. Matte _________________________________________________________________ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com