Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a database that was written in Access 2000. One of the users accidentally converted the file to the new accdb format in Access 2007. Is there a way to convert the file back to the mdb format?

    Tom

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='TomGoodwin' post='762292' date='27-Feb-09 18:33']I have a database that was written in Access 2000. One of the users accidentally converted the file to the new accdb format in Access 2007. Is there a way to convert the file back to the mdb format?

    Tom[/quote]
    From the Help File :
    Click the Microsoft Office Button , and then point to Save As.
    Note If no object is currently selected in the Navigation Pane (Navigation Pane: The pane that appears when you open an Access database or an Access project. The Navigation Pane displays the objects in the database, and can be customized to sort and group objects in different ways.), the Save As command may be unavailable (it appears dimmed). However, the items on the submenu are still available.

    Under Save the database in another format, do one of the following:
    To save a copy of the database in a format that can be opened by using Access 2002 or later, click Access 2002 - 2003 Database.
    To save a copy of the database in a format that can be opened by using Access 2000 or later, click Access 2000 Database.
    In the Save As dialog box, in the File name box, type a name for the database file, and then click Save.
    Francois

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. I will have them following these instructions.

    Tom

    [quote name='Francois' post='762293' date='27-Feb-2009 14:39']From the Help File :
    Click the Microsoft Office Button , and then point to Save As.
    Note If no object is currently selected in the Navigation Pane (Navigation Pane: The pane that appears when you open an Access database or an Access project. The Navigation Pane displays the objects in the database, and can be customized to sort and group objects in different ways.), the Save As command may be unavailable (it appears dimmed). However, the items on the submenu are still available.

    Under Save the database in another format, do one of the following:
    To save a copy of the database in a format that can be opened by using Access 2002 or later, click Access 2002 - 2003 Database.
    To save a copy of the database in a format that can be opened by using Access 2000 or later, click Access 2000 Database.
    In the Save As dialog box, in the File name box, type a name for the database file, and then click Save.[/quote]

  4. #4
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The user converted the database back to Access 2000. When I try to open the switchboard, I get a User defined type not defined error

    The fist line in a Private Sub Fill Options()
    Dim dbs As Database

    Is highlighted.

    Do you know how to correct this problem?

    Tom





    [quote name='Francois' post='762293' date='27-Feb-2009 13:39']From the Help File :
    Click the Microsoft Office Button , and then point to Save As.
    Note If no object is currently selected in the Navigation Pane (Navigation Pane: The pane that appears when you open an Access database or an Access project. The Navigation Pane displays the objects in the database, and can be customized to sort and group objects in different ways.), the Save As command may be unavailable (it appears dimmed). However, the items on the submenu are still available.

    Under Save the database in another format, do one of the following:
    To save a copy of the database in a format that can be opened by using Access 2002 or later, click Access 2002 - 2003 Database.
    To save a copy of the database in a format that can be opened by using Access 2000 or later, click Access 2000 Database.
    In the Save As dialog box, in the File name box, type a name for the database file, and then click Save.[/quote]

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Select Tools | References... in the Visual Basic Editor.
    There will probably be at least one reference beginning with MISSING. Clear the check box(es) for those.
    Set a reference to the Microsoft DAO 3.6 Object Library, if it's not already set.

  6. #6
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. This fixed the problem.

    Tom

    [quote name='HansV' post='763097' date='03-Mar-2009 11:45']Select Tools | References... in the Visual Basic Editor.
    There will probably be at least one reference beginning with MISSING. Clear the check box(es) for those.
    Set a reference to the Microsoft DAO 3.6 Object Library, if it's not already set.[/quote]

Posting Permissions

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