Creating mdb files for Streets with MS Access 2010 or 2013

Section for FAQs regarding i-Tree Streets (STRATUM)

Moderators: i-Tree Support, i-Tree Team

Post Reply
Jason.Henning
i-Tree Team
Posts: 340
Joined: Fri Dec 21, 2012 7:45 am

Creating mdb files for Streets with MS Access 2010 or 2013

Post by Jason.Henning » Fri Feb 01, 2013 11:52 am

MS Access 2010 and 2007 created .accdb files by default and do not offer the ability to create .mdb files once a database is created. To avoid this limitation it is possible to make MS access create a .mdb file using the following steps.

Launching Access displays the following screen.
Image

Select the “folder icon” next to the FileName box at the lower right. This will open the ”File New Database” dialog as shown below, which will then allow you to select an alternate or older Access file type by selecting the “Save as Type” drop down option. Select (2002 -2003 format)(*.mdb) and you can then use that database shell to import external data from a spreadsheet.

Image

Select (*.mdb) and you can then use that database shell to import external data from a spreadsheet.
Post Reply