Check database schema?

Question

The program checks whether or not the database file has the proper tables with the correct columns (it's in Access). Is there a way to do that? I want this so that the user can switch database file, but before the program uses the database file, I have to make sure it has the correct format. Thanks.

Answer 1

There is no simple solution. Check tables presence, columns, constraints ... much more properties. You must choose few of them but not all, it'l be too expensive. Try to select one or few rows to get datatable structures.