We've got a VBA macro and would like to log when whenever someone runs it and the context (what record were they in at the time). So basically, I want to capture the Date, Time, UserName, and ConstituentID-UserName of the record they were in at the time. Ideally, I'd like to send this information to a SQL table in a database on the same server as RE, but not the RE database. I have some code I've created for pulling information out of SQL and pulling it into RE and I was going to use that. However, I realized that it depends on having a DSN pointing to the other database and I don't want to do that for all of my users.

I'm very handy with SQL - much less so in VBA.

Does anyone have anything that might fit the bill?

Thanks!

Mitch