accdb vs mdb access database file

what is the di开发者_如何学JAVAfference between these two extensions?

i need to write to an access database from a WORD file using an ADODB connection

when i create a new access database it gives me the option to make only an ACCDB file and for some reason i cannot make an MDB file

can someone please help me create an MDB file so that i am able to make an ADODB connection to it in order to write to the database/?

Look at this explanation.

Also, in Access, 'save as' will give you older versions to save as (including .mdb).

(from above link) by using the ACCDB format, you will be able to:

• Include attachments in your database. (supports BLOBs)

• Use multivalued fields. (store "check all that apply" in one field)

• Safe integration with SharePoint and Outlook (you can e-mail accdb and Outlook won't block them)

• Encryption improvements

ACCDB databases do not support user level security or replication.