Converting Microsoft Access Databases Between Versions (ACCDB/MDB)

Converting Microsoft Access Databases Between Versions (ACCDB/MDB)

With the release of Access 2007, a newer file format (ACCDB) was introduced and suddenly users and developers were confronted with a mix of versions and formats to contend.

Therefore, converting Microsoft Access databases between versions required some careful and additional planning for your database. 

Here’s a five minute video tutorial which demonstrates using Access 2013 where and how to convert between the two common file formats.

httpvh://www.youtube.com/watch?v=Spznt3M1wUk

Converting Microsoft Access Databases Between Versions (ACCDB/MDB)

From the tutorial, it clearly highlighted the ease of use and users can convert an Access database with the additional ability to just copy individual objects as a quick copy and paste alternative. 

However, there are some additional points to highlight here that will Continue reading “Converting Microsoft Access Databases Between Versions (ACCDB/MDB)”

MS Access Database Forms: Using The SelStart And SelLength Properties

MS Access Database Forms: Using The SelStart And SelLength Properties

Have you noticed when you navigate between control fields in your MS Access database forms that it automatically selects the entire content (if not empty) instead of placing the cursor to the end of the last character?

ms access database design form

Using some simple Access VBA code, you can now control the placement for the cursor to mimic and automate placing the insertion point Continue reading “MS Access Database Forms: Using The SelStart And SelLength Properties”