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

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
mlagrangeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not aware of any event that does this. Interesting thought though.
Just curious why you want to know this ?

mx
0
 
Jeffrey CoachmanMIS LiasonCommented:
^
Me too.

Please describe in detail here what you are trying to do...
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
mlagrangeAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
I don't know of any such utility.

Let's see what MX posts....
0
 
mlagrangeAuthor Commented:
Ok, thanks for the response
0
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.

All Courses

From novice to tech pro — start learning today.