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

    New databse name has the default extension *.adp, not accdb

    I want to create a new database manually. The train of events is as follows (doing it exactly as described in the “Step by Step” book by Joyce Cox and Joan Lambert):

    • From the File tab I select Empty database
    • I move over to File name and baptize my file “MyTables” (no extensions)
    • From the browse button I navigate to the correct storage location
      • A window pops up. The displayed name is now MyTables.adp. The dropdown window has only one (and peculiar) choice, namely


    Microsoft Access-2D;databases (2002-2D;2003-2D;format)(*.mdb)-0;Microsoft Access-2D; ……. (long string)



    I do not accept suggested name, but rename to MyTable.accdb. The program doesn’t seem to like this name and add another extension (MyTables.accdb.mdb)-0.

    There seems to be a bug in my head in or in the program.

    Additional information:
    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!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    Cannot replicate the issue.

    Maybe reinstall Access?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    Sounds like a bad install. I just installed A2010 and my default is database1.accdb

    For intro tutorials watch https://www.youtube.com/watch?v=pHiO...feature=relmfu and subsequent videos

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

Similar Threads

  1. Replies: 5
    Last Post: 11-06-2012, 05:05 AM
  2. Database with extension mld
    By kstieb in forum Import/Export Data
    Replies: 6
    Last Post: 09-06-2012, 12:38 PM
  3. accdb database logging in as Admin by default
    By teja in forum Database Design
    Replies: 1
    Last Post: 03-19-2012, 06:42 AM
  4. cannot change extension from accdb to accdr
    By everette in forum Access
    Replies: 4
    Last Post: 05-01-2011, 03:47 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