Change database's creation date

[smjuukeiz]

Hi guys! I'm from Latvia and I really need your help. I didn't find any help in my native language and forums located in my country.
So I am here to ask you to help me. May I?
Well, I really need to change the date when my database is created! I manage to change the date in "properties" (mouse right click->properties) with one tool but I need to modify it in the "statistics tab"
When we open the database File-> database properties-> statistics tab. There the creation date still remains the original.
Please look at the picture: img133.imageshack.us/img133/2940/hehnc8.jpg
Some month ago I succeed to google the answer but now I cant find it

I remeber I had to create a VB module or macros, wrote some code and then run it and all was done!
PLEASE HELP ME! I really hope some of you guys will take seriously my problem.. Really need your help!

 

[maxmangion]

hi and welcome to the forums

If you would like to set today's date for your database creation what you can do is create a new database (so that it will have today's date) and import all of your objects into the new database container.

Hope this helps

 

[smjuukeiz]

Thanks you for replying!
Well that's not exactly what I'm looking for.. I need an option to change to any date I want.. As I said it is possible. I googled the answer a few month ago but I can't find it anymore!
As far as I remember I had to create a module in VBasic (some code there) & then run it! maybe I'm wrong and I had to create a macros and then run it.. One of this for sure!
Hope somebody will have any ideas!

 

[maxmangion]

check this link they have a freeware utility which does what you want.

 

[smjuukeiz]

check this link they have a freeware utility which does what you want.

I tried but these kind of applications just changes the file properties when we right click on the .mdb file but what I need is to change Database Properties which is located on the File menu after you open the file in Access. There's the Statistics Tab and there it still remains the same.

 

[maxmangion]

a quick google search revealed this link where it seems you need to do this for an illicit reason ... thus i can't help you any further.

 

[KenHigg]

See if this helps

 

[smjuukeiz]

a quick google search revealed this link where it seems you need to do this for an illicit reason ... thus i can't help you any further.

Teacher wanted me to create at least three tables and to make me 20 different kind of SQL queries.
Well, to economy time I just took basic Database from my friend who has graduated already. He allowed me to take his work for my needs. I have the knowledge to do it by myself but I'm out of time because I also have a job. So I decided to make the neccessary changes in my friends Database but the created date is too far in the past!
I think we could call it white cheating. Am I so bad because of it?

See if this helps

Really appreciate your help but it didn't work as I want it to
Yes it did change the file properties (look in the pic)

but what I need is to change the Database Properties on the File menu (when I open the file in Access). Hope you understand what I mean.. Please, see the pic:

 

[KenHigg]

Why are you beating your head against the wall on this? Change the system date on your computer to what ever you want then create a new .mdb and import all of the objects over - ?

 

[georgedwilkinson]

I don't call this white cheating, I call it cheating.

Any particular reason you don't want to learn how to do this yourself? Not that it matters, I'm putting you on ignore.

 

[smjuukeiz]

I don't call this white cheating, I call it cheating.

Any particular reason you don't want to learn how to do this yourself? Not that it matters, I'm putting you on ignore.

And so? Stop being such a idealistic and naive philistine! It's a life which pushes me to gain a goal with almost any method. Do I harm anyone if I cheat like this? NO
Reason why I do not want to do this by myslef? Have no time!

Why are you beating your head against the wall on this? Change the system date on your computer to what ever you want then create a new .mdb and import all of the objects over - ?

Thnx for the advice! I'll try and then edit this post!
edited:
Thanks again! It really worked out for me fine! I'll stop beating my head against the wall

 

[KenHigg]

And so? Stop being such a idealistic and naive philistine! It's a life which pushes me to gain a goal with almost any method. Do I harm anyone if I cheat like this? NO
Reason why I do not want to do this by myslef? Have no time!

Yeah... I agree with them on the cheating part - You're going to be cheating yourself when it comes crunch time and you don't know how do the work yourself. Anyway good luck with it

 

[chergh]

Do I harm anyone if I cheat like this? NO

Yes you cheat others who do the work themselves and you also cheat employers who employ you based on qualifications you get and don't deserve. You also seem to think your entitled to things without doing any work. All in all you sound like a moron.

Hope you fail

 

[smjuukeiz]

Yeah... I agree with them on the cheating part - You're going to be cheating yourself when it comes crunch time and you don't know how do the work yourself. Anyway good luck with it

Yes, I completely agree with you! But with my future problems which may accure later I'll deal also later!
In this situation I have no other solution
Thanks to you all guys especially KenHigg! Have a nice day! You made my day! Cheers!

 

[KenHigg]

You're welcome. I think...

(Why do I feel like an accessory to a crime here )

 

[smjuukeiz]

Yes you cheat others who do the work themselves and you also cheat employers who employ you based on qualifications you get and don't deserve. You also seem to think your entitled to things without doing any work. All in all you sound like a moron.

Hope you fail

What a pussy! I'm sorry for you.. with such a honest attitude you will suffer a lot in your life..
Why do you think I'll cheat employers? I have never said that I will be an employee. I have never said that I will work close to my specialty.
Idea is that I will study completely another specialty after this year. I just have to get my first higher education diploma.
What a big deal if I found a little bit easier way to do my homework! I was out of time and I had to! It's just one homework! I do not cheat in my exams.

Why do I feel like an accessory to a crime here

Stop feeling so. No crime here. You didn't help me to fake my diploma! It's just one homework ( I have every week few of them) No big deal!

 

[Rabbie]

You're welcome. I think...

(Why do I feel like an accessory to a crime here )

Because deep down you know you are helping him to cheat. If he hasn't got the ability to work it out for himself he shouldn't be told how to do it.

 

[smjuukeiz]

Because deep down you know you are helping him to cheat. If he hasn't got the ability to work it out for himself he shouldn't be told how to do it.

..said person you have never ever cheated! Yeah right..!
I have an ability to work out it by myselft. I already told that I just HAVE NO TIME! There's no big deal. It's just a small homework but it's deadline is very close! I didn't stole whole work just took the basics! SQL queries I wrote by myself. It will not affect my exam result! So piss off!

 

[KenHigg]

oh dear...

 

[Rabbie]

..said person you have never ever cheated! Yeah right..!
I have an ability to work out it by myselft. I already told that I just HAVE NO TIME! There's no big deal. It's just a small homework but it's deadline is very close! I didn't stole whole work just took the basics! SQL queries I wrote by myself. It will not affect my exam result! So piss off!

If you could work out how to change the database creation date yourself and you are in such a rush then why didn't you just do it and not waste everyone's time here