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!!