MS-Access.mdb compiler?

Question

Does anyone know a tool that can create an MS-Access database from a configuration file? It should be able to do something outside the SQL specification, for example, be able to create macros, modules, and forms and make changes to the Search tab, available in the design view.

And if possible, I need to be able to export the existing database to the configuration file format.

The reason I need this is because we are currently checking the .mdb file with almost 200 tables in CVS, so it is often checked. And since this is a binary file, there is no easy way to distinguish between two different versions of a file.

I suppose I could use all of this programmatically using vbscript, but there certainly should be an easier way.

Answer 1

You do not need to check the wholesale .mdb binary. MS Access supports Visual Sourcesafe, which provides more accurate grain management. I used it in anger and it works great.

Using Visual SourceSafe in Microsoft Access

Failed to find: How do you use version control when developing Access?

Answer 2

SaveAsText LoadFromText / : Application.SaveAsText acForm, "MyForm", "c:\form.txt MDB. Application.LoadFromText acForm, "MyForm", "c:\from.txt"

http://www.datastrat.com/Code/DocDatabase.txt MDB. http://iridule.net/cu/index.htm (). MS Access, SaveAsText LoadFromText,

, CVS, Microsoft SourceSafe, .

Answer 3

/ , ms- ​​ 'saveAsText'/'LoadFromText', . , "File Compare Tool".

, ths, . ms

But unfortunately, the saveAsText method is pretty inefficient when it comes to comparing tables where you need to compare data and structure! Text files created by this method compare only the contents of the table, but not the structure of the table. You need to either write your own tool, or find one that suits your needs on the Internet (I believe that you will use Google as something similar to a mapping table with the ms protocol).