When creating a new database manually the default name gets the extension *.adp (while I would expect it to be *.accdb).
When creating a new database manually the default name gets the extension *.adp (while I would expect it to be *.accdb).
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.
Thanks. Is there any way to make accdb the default file extension?
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?
Follow these steps to change the default file format in access database 2010:
- Open Microsoft Access 2010>>Open the File menu>>select Options at the bottom of the list.
- 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.
- 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.
- Click OK.
- New databases will be created using the default format, unless overriden by the user.
Thanks Tanvi
My setting are exactly as you describe. I will reinstall Access, and hope that will solve the problems.