Ms-access – Working with multiple programmers on MS Access

ms-accessversion control

Would you recommend working with multiple programmers on an MS Access application?

One of our MS Access application has grown to the point where the number of changes (bug fixes) and new features can no longer be handled by one programmer in the requested time frame.

We are trying to introduce version control using the undocumented SaveAsText and LoadFromText procedures in VBA to make collaboration on this application possible. Unfortunately we have already run into problems loading modified forms and reports back into Access as a checksum is stored in every form text file.

Before putting time into building an import/export application to compile text files into an Access database, we would like to hear your recommendations.

Best Answer

I think you should avoid this path at all cost, and try and persuade management into redevelopment.

It's a bitter pill to swallow, but this is going to need to be redeveloped sooner or later, and you are just saving them time and money.