How to check Installed Version of RAM SS in VBA for use with DataAccess

Hello,

I know that it is recommended that the RAM database file version be checked if it meets the minimum compatible version needed to run the Data Access code but I would also like to be able to check to see if the RAM database file matches the installed version of RAM SS. I'm wondering if there is a way to do this with Data Access or perhaps just within the VBA programming language so that I can make sure that the database file doesn't need to be upgraded or the user running the code does not need to update there version of RAM SS.

Thanks!

  • Hello Robert,

                    There are two (2) methods that you will want to use together:

                     In interface IRamDataAccess2 use the method GetVersion() to get the version of the current RAMDataAccess(.dll):

     [id(1), helpstring("Get version of DataAccess")] HRESULT GetVersion([out, retval] double *pdVersion);

                     And in interface IDBIO1 use the method GetDataBaseVersion() to get the version of the RAM Database:

     [id(8), helpstring("GetDatabaseVersion")] HRESULT GetDatabaseVersion([in] const BSTR bstrDBName, [in, out] double* pdVersion);

     Greg

    Answer Verified By: Robert Vida