Results 1 to 6 of 6
  1. #1
    erikl1 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    31

    New database get the extension *.adp (not *.accdb). Why?


    When creating a new database manually the default name gets the extension *.adp (while I would expect it to be *.accdb).

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Don't have Access on this machine, but adp is Access Data Project, which is one way to connect to SQL Server. Presumably you chose that instead of a standard database. The adp has been deprecated anyway, so I personally wouldn't use it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    erikl1 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    31
    Thanks. Is there any way to make accdb the default file extension?

  4. #4
    erikl1 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    31
    Creating databases manually:

    • I enter the file name (MyTables – no extensions)
    • I use the browse button to navigate to the correct storage location
    • A new databasewindow pops up. The displayed default name is now MyTables.adp
      • The dropdown menu for the selecting the file type has only one (and peculiar) choice, namely Microsoft Access-2D; databases (2002-2D;2003-2D;format)(*mdb)-0; ………

    I would expect a dropdown list with many choices.

    Additional information (possibly related):
    When starting with a clean table the ID counter is empty. For evey new Field I add the ID counter increase one step. Adding 7 fields thus displays ID = 7 on my first record!!

    Could there be a bug in my head or in the program? Is reinstallation on my agenda?

  5. #5
    tanvi is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    100
    Follow these steps to change the default file format in access database 2010:

    1. Open Microsoft Access 2010>>Open the File menu>>select Options at the bottom of the list.
    2. You will now see the Access Options window (shown in the illustration), opened to the General tab. Locate the "Default file format for Blank Database" entry under "Creating databases" in the middle of the screen.
    3. Select the pull-down menu next to "Default file format". If you would like to use ACCDB format, choose "Access 2007". Otherwise, if you would like to use an older format, select the appropriate version of Access.
    4. Click OK.
    5. New databases will be created using the default format, unless overriden by the user.


  6. #6
    erikl1 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    31
    Thanks Tanvi

    My setting are exactly as you describe. I will reinstall Access, and hope that will solve the problems.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database with extension mld
    By kstieb in forum Import/Export Data
    Replies: 6
    Last Post: 09-06-2012, 12:38 PM
  2. accdb database logging in as Admin by default
    By teja in forum Database Design
    Replies: 1
    Last Post: 03-19-2012, 06:42 AM
  3. cannot change extension from accdb to accdr
    By everette in forum Access
    Replies: 4
    Last Post: 05-01-2011, 03:47 AM
  4. how to display the extension file access 2007
    By tintincute in forum Access
    Replies: 4
    Last Post: 08-04-2010, 10:09 AM
  5. access file extension help
    By supertech33 in forum Access
    Replies: 2
    Last Post: 02-17-2010, 03:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums