I’m trying to figure out how to clear all of my data from all tables so I can import data from my live Access application.
There are so many foreign key relationships, it keeps telling me I can’t truncate a table where there are live foreign keys pointing to other tables. this seems to be a catch-22. I thought if I deleted all join table data first then it would work, but can’t seem to do this. Is there a quick way to delete all data from all tables?
Is there an easier way to see what records are in a given table other than opening up a new query window and querying the data using SQL?
thanks…