If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Created Date and User who Created
How can I return with access programming the following
information of an access file: 1). The created date and time. 2). The user that created it. Thank you for your help, Steven |
#2
|
|||
|
|||
Created Date and User who Created
Steven
There's more than one way to interpret your request... Are you asking to note the create date/time/user of the entire Access MDB file? If so, check on properties. Are you asking to be able to show who changed a record and when in a table within an Access MDB file? If so, you'll need to add these fields to your table(s) and add code to your forms to write this information. -- Good luck Jeff Boyce Access MVP |
#3
|
|||
|
|||
Created Date and User who Created
That was not much help. If you dont know the answer please
do not put anything. People will bypass if there is a response and you answered nothing. -----Original Message----- Steven There's more than one way to interpret your request... Are you asking to note the create date/time/user of the entire Access MDB file? If so, check on properties. Are you asking to be able to show who changed a record and when in a table within an Access MDB file? If so, you'll need to add these fields to your table(s) and add code to your forms to write this information. -- Good luck Jeff Boyce Access MVP . |
#4
|
|||
|
|||
Created Date and User who Created
Guess
The original post was ambiguous. My response offered two approaches and left the door open for further clarification. If you judged that to be non-responsive, my apologies. Jeff Boyce Access MVP |
#5
|
|||
|
|||
Created Date and User who Created
That was not much help. If you dont know the answer please
do not put anything. People will bypass if there is a response and you answered nothing. Hey, please lighten up. The original question was vague and Jeff's response was absolutely valid. Seemingly simple questions do not always have simple answers. If you know the answers to Steven's questions, why don't you answer them yourself? If you don't know, how can you evaluate Jeff's response? If Steven didn't get everything he needed from Jeff's feedback, he can ask a follow-up and include more detail about what he's looking for. Jay |
#6
|
|||
|
|||
Created Date and User who Created
I am just frustrated. I did not think anyone would
actually read what I wrote. I should have just reposted the question without venting. I understand not actually speaking with the person can create difficulties. I will have to call MS and make an over the phone case or make an internet case. My thinking was that since CurrentDB.Name returned the directory and name there must be an easy command I have overlooked to tell the date an mdb or mde file was created or modified. I did get a response from a different posting saying to put it in a shared hidden directory. I did not know you could open a mdb or mde in a hidden directory. This is an incredible service. I must say that I probably have spent approx $5,000 over the last 2 years on cases with MS but that is really ok because I would not ever get anywhere without all the services...especially this one. Thanks and keep up the good work. Steven. .. |
Thread Tools | |
Display Modes | |
|
|