Created Date and User who Created

[Steven]

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

 

[Jeff Boyce]

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.

 

[Guess Who]

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.

 

[Jeff Boyce]

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>

 

[Jay Vinton]

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

 

[Steven]

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.
..