I know that if I have a program with a connection to an Access database, if I change the name of a table in the database, when I try to access that table from within the program, it's going to throw an exception.
My question is, how do I cause the dataset to use the new table name? Do I have to recreate the dataset? The dataSOURCE reflects the new table name, but the dataset is still using the old table name.