Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    56

    Unanswered: Need help to Determine .mdb version

    Currently I have been tasked with identifying the literal thousands of .mdb files our organization uses and make a determination of the .mdb version (Access97 or Access2003) and record the path, dbname, file size, date created, date LastUpdated, and version.

    I have accomplished all of the above except being able to determine the .mdb version (whether it is in 97 or 2003 format). I have used the
    SysCmd(acSysCmdAccessVer) in my code (code scripted in Access97 to prevent accidental opening of 97 db's in 2003). The problem is that I cannot determine which .mdb file was created by 2003.

    I thought the SysCmd provided that information, but it appears not to work.

    Any suggestions?

    Thanks,

    John

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi John

    I would have thought it would work fine - what exactly happens?

    Also - if you can identify the 97, 2K and XP dbs - any that are left are 2003 huh?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2006
    Posts
    56
    Hi Pootle, thanks for the quick reply.

    It returns the value of the 2003 database as version 8. I was expecting it would return it as version 9.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hang on - I've just realised - doesn't acSysCmdAccessVer return the version of the application not the database? 2003 should return 11 in any case. The reason it is returning 8 is because you are running the code in A-97. Run the code in A 2k and you will get 9.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    There is a property called FileFormat for CurrentProject that gives the version of the current project. I only found it be checking different properties. It is probably going to be an issue with 97 (before Projects) and then I am not sure how you you would use it opening other databases, but...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •