 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / March 2006How to Auto-Document Access 2003?
Hi, I have an Access 2003 application which I have to enhance. The former programmer isn't available any more. Does anybody know a good tool which documents Access 2003 applications? Steven There is a built-in documenter under: Tools | Analyze | Documenter There is a better documenter here: http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html If it is the table structure and relations you want to document, there is a new utility here that enhances the relationships report by adding field info: http://allenbrowne.com/AppRelReport.html  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > I have an Access 2003 application which I have to enhance. The former > programmer isn't available any more. Does anybody know a good tool which > documents Access 2003 applications? > > Steven Hi Allen, I am not sure you noticed my remarks concerning 'scrollbar-tables' in the view? http://groups.google.com/group/comp.databases.ms-access/msg/3f86ea68aa7fe048 Arno R > If it is the table structure and relations you want to document, there is a > new utility here that enhances the relationships report by adding field > info: > http://allenbrowne.com/AppRelReport.html Hi Arno I did see your message but was not able to identify where the problem lies. This screenshot of Northdwind has scrollbars in all sorts of states, but AFAICT, the report matches the screen view: http://allenbrowne.com/temp/NWindRel.jpg If you can help me identify where it is wrong, that would help. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. Hi Allen, I am not sure you noticed my remarks concerning 'scrollbar-tables' in the view? http://groups.google.com/group/comp.databases.ms-access/msg/3f86ea68aa7fe048 Arno R "Allen Browne" <AllenBrowne@SeeSig.Invalid> schreef in bericht news:4407ed25$0$21859$5a62ac22@per-qv1-newsreader-01.iinet.net.au... > If it is the table structure and relations you want to document, there is > a > new utility here that enhances the relationships report by adding field > info: > http://allenbrowne.com/AppRelReport.html Hi Allen, As I wrote: The problem shows up when there is a relation to the second or third field (in the fieldorder that is) AND we do *not see* the *first* field in this 'scrollbar-table' (e.g. we scrolled down the list). Example Nortwind: If you would scroll the table Products in a way so that you don't see the field ProductID in the relationshipsview, but you see the field ProductName as your first field, then the problem will occur. -- You will see that the relation from the Suppliers table links to the field ProductName -- You will see that the link from the Categories table 'connects' to the field SupplierID. So you have to make sure that you 'see' the first field in the relationships window... Arno R > Hi Arno > [quoted text clipped - 22 lines] >> info: >> http://allenbrowne.com/AppRelReport.html Thanks for your comments, but I still can't repro this. Tried with the Products table in A2000 and 2003, but did not see the issue. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. Hi Allen, As I wrote: The problem shows up when there is a relation to the second or third field (in the fieldorder that is) AND we do *not see* the *first* field in this 'scrollbar-table' (e.g. we scrolled down the list). Example Nortwind: If you would scroll the table Products in a way so that you don't see the field ProductID in the relationshipsview, but you see the field ProductName as your first field, then the problem will occur. -- You will see that the relation from the Suppliers table links to the field ProductName -- You will see that the link from the Categories table 'connects' to the field SupplierID. So you have to make sure that you 'see' the first field in the relationships window... Arno R "Allen Browne" <AllenBrowne@SeeSig.Invalid> schreef in bericht news:44082d8b$0$21900$5a62ac22@per-qv1-newsreader-01.iinet.net.au... > Hi Arno > [quoted text clipped - 23 lines] >> info: >> http://allenbrowne.com/AppRelReport.html > Thanks for your comments, but I still can't repro this. > > Tried with the Products table in A2000 and 2003, but did not see the issue. Sorry for getting back so late, I have been away this afternoon ... Check out: http://home.tiscali.nl/arracom/relations.html Hope you see the problem now. Look at the relations between 'Leveranciers' and 'Producten' Arno R Thanks: I can see it in your sceenshot, though I cannot repro. it. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Allen Browne" <AllenBrowne@SeeSig.Invalid> schreef in bericht news:44083f94$0$21891$5a62ac22@per-qv1-newsreader-01.iinet.net.au... > Thanks for your comments, but I still can't repro this. > > Tried with the Products table in A2000 and 2003, but did not see the > issue. Sorry for getting back so late, I have been away this afternoon ... Check out: http://home.tiscali.nl/arracom/relations.html Hope you see the problem now. Look at the relations between 'Leveranciers' and 'Producten' Arno R > Thanks: I can see it in your sceenshot, though I cannot repro. it. Strange, could this be a localisation problem? Maybe others can try to test this also? 'Scrolled' some more tables: http://home.tiscali.nl/arracom/relationstotallywrong.jpg Could you zip and mail your version of the Nortwind.mdb please? I will check if I can do the same with that mdb (change the relationship-window) and mail it back to you Arno R I've written code that creates tables of queries/tables in an Access database, with enumerated data types, as well as outputs all modules into a folder of text files. With some table creation, as well as code modification to point it at a directory, you can keep a running record/backup of changes: http://code.comparative-advantage.com/download.php?RecordID=6 James Igoe Access/Excel VBA Developer http://code.comparative-advantage.com/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.