For those who use SQL Management Studio, I share the following trick that I learnt from someone at the IA:
Open the database called FundingInformationSystem and then open the table called DataSet. The column called DataSetVersion should tell you the version number (unfortunately mine had two version ones, of the same database, whereas FIS reported versions 1 and 2, which I have reported to the DS). The column called DatabaseName tells you exactly that.
This is particularly useful if you are wanting to find out which database is which and your version of FIS has downloaded multiple versions of any of the databases, such as LARS..
You can also identify the latest version of a FIS database by running the following pass through query from Access:
SELECT dbid, name FROM master.dbo.sysdatabases WHERE Left(name,3)=’FIS’ ORDER BY dbid;
The one with the highest dbid will be the latest version.