Solved

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

Posted on 2013-05-15
6
238 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 500 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

705 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