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
2010-08-12 10:01:14
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
2010-08-12 16:14:47
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
2010-08-13 00:39:24
Yes. It uses a variation of Application.SaveAsText() to make the magic happen.
apenwarr
2010-08-13 03:38:17
So it uses different methods for the diffs for the data and the code part?
David-W-Fenton
2010-08-14 04:09:54