What I am making is a program which allows users to update the statuses of various networks. That part works perfectly fine. I am using a MS Access table to hold the actual data (for instance, Network Name and Status). My question is, is there a command or series of code I can use that will create a copy of the table I'm working from in it's current state, and name it with the current date/time within the same database? Basically I want to track what time the changes were made, thus being able to go back and see where any problems occurred. I'd like to also use a variable which contains user_id and put that in the file name as well, but it's not necessary. I haven't seen any other posts (and I've been through quite a few) with this issue, so any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating a Copy of a table on demand
- Thread starter zenenigma
- Start date
MichaelRed
Programmer
Not what you are asking for in detail, but perhaps a better approach. See faq181-291 if your users are interacting through bound forms, this shows how to create a transaction log. Easy to modify to suit your specifics.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
