Hi,
I've developed a MS Access application (UI) having linked tables from SQL Server.
The application would be used by multiple users (about 8 users) for record creation, deletion and update through forms (TextBox and ComboBox controls).
I was able to achieve/complete the development until record creation and deletion with user and date for creation/deletion tracking details, but stuck with tracking the record update process.
For tracking the user details, I'm using/storing the login ID as user used while logging into the access application.
Request your advise.
Note: I tried through doing it through macros but it didn't work.
Please let me know if any further information required.
Thanks,
Rakesh
I've developed a MS Access application (UI) having linked tables from SQL Server.
The application would be used by multiple users (about 8 users) for record creation, deletion and update through forms (TextBox and ComboBox controls).
I was able to achieve/complete the development until record creation and deletion with user and date for creation/deletion tracking details, but stuck with tracking the record update process.
For tracking the user details, I'm using/storing the login ID as user used while logging into the access application.
Request your advise.
Note: I tried through doing it through macros but it didn't work.
Please let me know if any further information required.
Thanks,
Rakesh