I have an MS Access database (mdb) file and I am writing an Asp.Net application (in C#) that I use to access and modify the data in the Access database.
I would like to be able to interrogate, through my Asp.Net application, the field (column) definitions of tables in the database, so that I can check that the correct fields exist in the database, and that they are the correct data type.
I seem to remember that I can use some kind of SQL SELECT statement to query the field (column) definitions of a table. Is this right? If so, can you please give me an example of such a SQL statement please?