I have an access database for a hotel room list which includes how many rooms I have available for each hotel. This list is updated via a form that updates the database, either adding or removing rooms. The database is on the server and is accessible by four employees, each of whom can update the hotel room number as they sell them.
The hotel rooms are in a table and this table is updated and records who updated it last by overwriting the previous update entry. I want to create a log file that records ALL updates each time the form is submitted, so I can track all transactions. I have not found any info on how this is done. Do I need to create a secondary table that only records when the form is submitted and database is updated? How do I do this?
You can use FileSystemObject to create files/edit.
Set Fso = Server.CreateObject("Scripting.FileSystemObject")
Set LogFile = Fso.CreateTextFile(Server.MapPath("."),8,true) 'Creates a text file on the same folder.
LogFile.WriteLine("[" & Now() & "] Transaction number: " & ID & ", More information")
Set Fso = Nothing
Set LogFile = Nothing
View the folder you'd like to access. Right click on it -> Properties.
On the tab Security you have the Groups or username's.
There you select the user you're using and below you have the permissions that user has.