tags:

views:

28

answers:

2

Hi, I've got a legacy MS Access DB. How can I see the changes made to that DB? e.g. changes of Code etc. Does MS Access store it?

+1  A: 

Access is file based, perhaps there is a previous copy, otherwise, you are out of luck.

Remou
A: 

If you use the EQL Data Plugin then you can track the current state of the database every time you upload it to the server. Then you can get diffs, etc between versions. (Disclosure: I work at EQL Data.)

Microsoft also makes a Visual SourceSafe plugin for Access that may be helpful to you, though it has a reputation for being buggy.

apenwarr
This works for code? That is, the stuff that's stored in that single BLOB field in a single record or one of the system tables?
David-W-Fenton
Yes. It uses a variation of Application.SaveAsText() to make the magic happen.
apenwarr
So it uses different methods for the diffs for the data and the code part?
David-W-Fenton