Retrieve them the same way you are retrieving data from other tables in databases. Setup a connection and populate a recordset from the table that they reside in, using a bit of SQL to return the required records.
Couldnt tell you what they are used for, I dont particularly use relationships (as such) in my developments - but other than managing keys from the look of it, I doubt they do very much at all. But fortunately MS Access knows how to use them, which is the main thing.
Personally, I think you are going so far over the top with documenting this (for what appears to be a tennis club database), cant imagine these being of use in any capacity in an actual development - unless you are developing your own RDBMS, so I assume it is for documentation.
You cannot write to these tables, anyway - so reading the data from them is, frankly, pointless - since to replicate any data in the table will require you to enter it in a totally different manner and format.
|
what is access 2000 syskeys and syscolumns data
