[AccessD] Access version

OK... now is there a way to determine the database container version?

I am getting an error "cannot open the database properties".  When I Google this it appears that it 
is caused by opening a container in A2K where the container was created in a later version.  This 
may in fact be the cause though I thought that Access 2K would refuse to open a later container at all.

I created my PLSS MDA in 2003 but I do not remember being given a choice of container, though I do 
remember being offered such a choice in the distant past.

John W. Colby
www.ColbyConsulting.com

On 9/7/2010 2:22 PM, Heenan, Lambert wrote:
> It's long and complicated, so fasten your seat belt...
>
> syscmd(acSysCmdAccessVer)
>
> Lambert :-)
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, September 07, 2010 2:03 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access version
>
> Access 97 and Access 2K have "issues" with using event handling in classes, in particular with storing a pointer to the form in the class and then closing the form without first intentionally closing the class.  These issues were fixed in Access 2002 and above.
>
> As a result of these issues, I need to force the form close to go through a button where I can insert cleanup code, thus I need to make sure the AllowClose button is not enabled in these environments.
>
> I have never used code that figures out the version.  Does anyone have such code?
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>