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.
Course Of The Month
4 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
data macro get username without vba
Posted on 2014-11-20
After much web surfing, I see data macros that reference VBA must have the VBA in the database that is making the data changes. So if someone links to the database and makes data changes, we can't grab their user name unless they have the GetUserName function in their database.
We think someone is changing data from another database but we can't tell who and we don't want to rely on everyone remembering to put the GetUserName function in every database they create or even make a reference to a database that has that function.
Has anyone come up with a solution that doesn't require VBA?
We think someone is changing data from another database but we can't tell who and we don't want to rely on everyone remembering to put the GetUserName function in every database they create or even make a reference to a database that has that function.
Has anyone come up with a solution that doesn't require VBA?
[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
5 Comments
Active today
That is not possible. If someone has been granted rights to the database file and has a tool to modify records it, it leaves no traces.
You'll have to monitor this at the server level via session and/or open files.
/gustav
You'll have to monitor this at the server level via session and/or open files.
/gustav
Active 1 day ago
What version of Access? 2010 introduced the concept of data macros, which you may be able to use to log when the data was changed. As Gustav said, you can't really log who did it, but knowing when it changed might give you more information to determine who changed it.
Active 1 day ago
<<Has anyone come up with a solution that doesn't require VBA? >>
As the others have said, with a JET/ACE db, there are none. Tracking must be built-in.
However with something like SQL Server, you could use transaction logs to determine who is making changes.
The reason you can do that is that no client directly touches the database on its own, everything goes through one central process.
With JET/ACE, every client touches the database directly, so unless it's built into the app, there is no tracking.
Jim.
As the others have said, with a JET/ACE db, there are none. Tracking must be built-in.
However with something like SQL Server, you could use transaction logs to determine who is making changes.
The reason you can do that is that no client directly touches the database on its own, everything goes through one central process.
With JET/ACE, every client touches the database directly, so unless it's built into the app, there is no tracking.
Jim.
Active today
You can control some things by making certain fields required and also by creating relationships and establishing RI. In the BE, you need a table of authorized users. In EVERY table, you need an UpdateBy column. UpdateDT and CreateDT will also be useful. Make the UpdateBy required and create a relationship with the Authorized users table and check the box to enforce RI. That will force all Adds at least to log who made them and when. I'm not sure what the capabilities of DataMacros are since I don't use them (I use SQL Server if I have requirements that must be implemented via triggers.) but you may be able to look at the pending update and determine that it has a userID destined for the UpdateBy field. You don't actually have to validate it since the RI will handle that. You just need to make sure it is present in the set of replacement data.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…
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…
- Phishing
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security, Security
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
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…
Suggested Courses
Course of the Month4 days, 17 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.