Loading

Check database schema?

supersonic_skymaster

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski22y ago
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.