Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quick way to determine file format of mdb (2003 sp1)

    I need a quick way for a casual user to tell if the MDB file they are using is in the Access 2000 format or the Access 2002-2003 format. I'm aware of the indication in the title bar of the database window, but is there any other way?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick way to determine file format of mdb (2003 sp1)

    Interactively:
    You can look at the Tools | Database Utilities | Convert Database submenu. The greyed out option corresponds to the current format.

    Automatic:
    You can put a (locked) text box on the startup form of the database, with Control Source
    <code>
    =IIf([CurrentProject].[FileFormat]=9,"Access 2000","Access 2002/2003")
    </code>

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to determine file format of mdb (2003 sp1)

    I was aware of the Convert Database submenu as well, and thanks for the suggestion for the automatic way.

    But that is not built into all databases at the moment.

    My organization has chosen to convert all MDB'S to the newest file format, Access 2002-2003. So I have instructions for the users on how to do that, but I was looking for a way for them to tell what version the MDB is currently on. So unless there is another way, I'll just instruct them to check the title bar, or maybe the Convert database sub menu, which ever turns out to be less steps for the users.

    Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick way to determine file format of mdb (2003 sp1)

    I'm not sure what kind of method you had in mind.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to determine file format of mdb (2003 sp1)

    Yeah, me either I guess. I thought there might be a hidden, right-click-on-the-mdb way or something, but must not be. Not a big deal.

    Thanks.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quick way to determine file format of mdb (2003 sp1)

    You can test the Jet version the database was created under using the Version property of the database. We use it all the time when testing to see if a data file needs to be migrated to a later version. You can do something like this:

    <code> Dim dbs As DAO.Database
    Set dbs = DAO.OpenDatabase(strDatabaseFileName)
    MDBJetVersion = dbs.Version
    Set dbs = Nothing
    </code>


    It won't give you something convenient like "Access 97", but it will give you the DAO/Jet version used to create the file.

    <table border=1><td>3.0</td><td>Access 95</td><td>3.5</td><td>Access 97</td><td>3.6</td><td>Access 2000/2002/2003</td></table>
    Charlotte

Posting Permissions

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