Lack of Database Documenter for Access 2013 Apps

When editing an Access 2013 App, the ribbon does not include the Database Documenter under the Database Tools tab. I understand that the reasoning behind this situation is that the data tables are being stored in SQL tables on SharePoint, but that doesn't make up for the frustration of not being able to generate the type of documentation which is possible for an Access 2013 Desktop program. Related to this is the lack of being able to graphically view the relationships between tables; again, I already understand that the "relationships" are built in a lookup field that gets values from a related field in another table. But knowing that doesn't solve the lack of being able to view and document what's going on... Any suggestions for documenting an existing Access 2013 App which is running on SharePoint?
DataQuestAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jacques Bourgeois (James Burger)PresidentCommented:
Use the tool that lets you work with SQL Server database structures: SQL Server Management Studio (SSMS).

The most recent version is available at http://msdn.microsoft.com/en-us/library/dn434042.aspx.

You won't be able to print reports for the documentation as you could in Access, but at least, you will have a good access to the tables structures and to the relations (defined in diagrams in SQL Server).

Note that a SQL Server database requires the proper security credentials in order to be able to access it's structure at the level that you might need. Ask your database manager if he is willing to give you the proper rights.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Is this a Web App? Or a Desktop app?

If it's a desktop app, one of the FMS tools might work: www.fmsinc.com. I use Total Access Analyzer, and it is the best documenter you'll find for Access.
0
DataQuestAuthor Commented:
James,
That link was helpful for pointing me in a direction where I could at least gain some insights. The Access 2013 Apps in Question are being run on SharePoint with an E3 subscription. Do you know whether Microsoft makes it possible to look at those SQL structures with the tool you were referring to?
Thank you.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DataQuestAuthor Commented:
Scott,
It's an Access 2013 App, not a Desktop "app"; my understanding is that the iteration which ran under Access 2010 included the word "Web."
That FMS website was very interesting, I am going to keep that one in mind for future needs.
Thank you.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It's an Access 2013 App, not a Desktop "app"; my understanding is that the iteration which ran under Access 2010 included the word "Web."
2013 can create both Web Apps and Desktop Apps - but it sounds like this was created in 2010 as a Sharepoint-hosted web database.

If so, then the documenter should be able to review the database structure to some degree.

If it's a Web App (i.e. you're running Office365 and you have to "launch" the app from a URL) then I'm not sure what could be done with that ...
0
DataQuestAuthor Commented:
Okay, it's a Web App. Purchased another book (published by Microsoft) and the distinction was much more clear.
Some points were awarded for suggesting the FMS site as a source of tools/information.
Thank you to you both!
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm curious - which book did you purchase?
0
DataQuestAuthor Commented:
The first book, which doesn't (to me) seem to emphasize "Web" App was: Professional Access 2013 Programming, by Teresa Henning, et al.
The second book, which does emphasize (SharePoint hosted) the term Access Web App was: Microsoft Access 2013 Inside OUT, by Jeff Conrad.
Both are very well written, and I am enjoying going through each of them.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.