I have just joined a company and my role is to upsize the current MS Access database to SQL 2K or 2005.
But I found that the database design of the access is really messing and the guy who developed it is fired already.
It is separated into more than 10 mdb file with link to each other to serve different purpose of business function, such as, 1) CRUD of client, 2) CRUD of client's project, 3) CRUD of project team and member, 4) CRUD of resource allocated to different project... etc.
Could anyone suggest some documentation tools which could document the 1)link of access file 2)purpose of each form in each access 3)meaning of field of each table/query ?