?
Solved

Any 3rd party tools out there for attaching notes to Access (2010) database objects?

Posted on 2013-05-15
6
Medium Priority
?
242 Views
Last Modified: 2013-05-17
Like a change log, or just general notes?

Any way to trap whatever internal event might fire w/in Access when an object is saved?

Right now, I'm just copying MSysObjects to a header table, and linking a child table of "LogDate" and "LogNotes".

Has somebody come up with anything better?

Thanks
0
Comment
Question by:mlagrange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 75
ID: 39168840
Not aware of any event that does this. Interesting thought though.
Just curious why you want to know this ?

mx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39170274
^
Me too.

Please describe in detail here what you are trying to do...
0
 

Author Comment

by:mlagrange
ID: 39171200
For about the last 3 years, I have been working in a combination development/production/support role for about 5 complex Access app's, and it is busting my brain, trying to keep up with the changes I wind up making; remembering why I did something a particular way in the first place, and why I had to make all the changes along the way, and incident logs, troubleshooting notes... I'm sure you know that drill.  

Back when Access was in version 2.0, there was a 3rd party app that was a combination code vault and change control log. It would trap the open and save events of Access objects within the database. The problem was that it required you to check the object out when you opened it, and then check the object back in when you saved it. This was an absolute pain in the ass during the trial and error of development. The developer didn't provide a way to get around that, and it went bust.

I'm just wondering if anybody knows (or has developed) a less-intrusive tool; maybe that would allow you to just right-click on an object, and enter individual, dated, categorized notes, in a more useable fashion than the tiny little "Description" box currently provided.

Like I said, I'm trying to do that now with a table I created from MSysObjects. I was just looking for a better, more polished utility than my own fiddle-farting around.

Thanks
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39171361
I don't know of any such utility.

Let's see what MX posts....
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 39171981
"This was an absolute pain in the ass during the trial and error of development."
Totally AGREE with that!

These two products sort of ... approach this:

http://fmsinc.com/MicrosoftAccess/VBACodingTools.html

http://fmsinc.com/MicrosoftAccess/Code.html

There is also 'Visual Safe Source', but I've heard plenty of horror stories about this also.

mx
0
 

Author Comment

by:mlagrange
ID: 39176581
Ok, thanks for the response
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question