I have a table which I believe I has been corrupted. I think my best solution at this point is to rebuild it (which isn't too big of an issue, since I have the data stored elsewhere and can import it). My concern the table has a number of relationships connected to it, and most importantly, a number of queries and reports which utilize those relationships. ANyone have any experience with deleting relationships, rebuilding a table using the exact same field names/types, reinstituting the relationships, then having problems with queries and/or reports? Do I need to rebuild the database from scratch? Am I best off creating the tables in a completely separate database, then importing the queries/reports/subreports in question?
Thoughts/opinions?