ms-jet-ace – Tarik Billa

How to extract the schema of an Access (.mdb) database?

December 11, 2023 by Tarik

It is possible to do a little with VBA. For example, here is a start on creating script for a database with local tables. Dim db As Database Dim tdf As TableDef Dim fld As DAO.Field Dim ndx As DAO.Index Dim strSQL As String Dim strFlds As String Dim strCn As String Dim fs, f … Read more

MS Access (MDB) concurrency

August 28, 2023 by Tarik

This is an old question, but nobody has ever actually answered it. Here are the questions: How are concurrent reads handled in MDB? How are concurrent updates/deletes handled in MDB? Is there a concept of locks and how can I leverage it in a .NET app? Is placing the MDB file on a network share … Read more