Results 1 to 11 of 11
  1. #1
    Lounger
    Join Date
    Oct 2002
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compacting resets 'Modified' and 'Created' details (2000)

    This has bothered me for a while, and I'm finally taking a minute to ask about it. I was glad to see Microsoft add the Date and Time stamp for objects creation and modification, but have been dissapointed by them being reset to the current time/date when the database is compacted. I don't see any way of avoiding this under Tools/Options.

    Does anyone know if there is a way to keep this information intact?

    Thanks,

    Howard


    ps: I was going to see if anyone else had asked this before posting, but can't find the 'Search' link.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Are you sure that the modification date/time of objects within the database changes when you compact it? I don't see that in my databases. The file modification date (in Windows Explorer) does change, and there is nothing you can do about that (except using a utility to set the date/time)

    Searching has been disabled temporarily due to overload of the Lounge, see <post#=250092>post 250092</post#>. A solution is being worked on at the moment, but unfortunately, we don't know yet how long it will take to have everything running again.

  3. #3
    Lounger
    Join Date
    Oct 2002
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Hans,

    I just compacted one of my databases that has a variety of objects in it. Although I'm pretty sure that every type of object was reset before, this time all Forms, Reports, Macros and Modules now show 5/14/2003 11:29:51 AM in Modified and Created. The Tables and Queries are still correct.

    I wonder if this is something that is just affecting me?

    Thanks for your reply,

    Howard

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Perhaps others can share their experience. I tested on Access 97 SR-2 and Access 2002 SP-2, not on Access 2000. Decompiling, then compiling code results in changed dates for all objects that contain code, but compacting doesn't - for me.

  5. #5
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    I find the same effect for compaction as An_Unchosen_Name did - i.e. Forms & Reports' dates change but queries' dates do not. (Using Access 2000 SP1)
    I do not know about decompiling as I always follow that with a compaction. I'll take a look tonight as I am overdue to do a de-compile (you can take that anyway you like! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> ) and see what happens.

    I assumed it was to do with Access resetting flags, autonumbers etc.. (some mysterious inner Access/Jet process anyway) and just learnt to live with it. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  6. #6
    Lounger
    Join Date
    Oct 2002
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Steve,

    Thanks, I was living with it too, but sure hope there's a way to stop it from happening. By the way, why do you de-compile your database(s)?

    Howard

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Wasn't that one of the problems that A2k had? It seems to me that it was and was never really sorted out in 2000.
    Charlotte

  8. #8
    Lounger
    Join Date
    Oct 2002
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    (Edited by HansV to make URL live - see <!help=19>Help 19<!/help>)

    Thanks for your reply Charlotte

    Actually, I was just able to find this in Microsoft's site (http://support.microsoft.com/default.aspx?...kb;en-us;244642) under "Created and Modified Dates for Objects Suddenly Reset", but the prognosis doesn't look promising. The Microsoft page was last updated on 11/20/2000 and says "Microsoft has confirmed that this is a problem in Microsoft Access 2000."

    I guess you are correct Charlotte - and it doesn't look like they will ever bother to fix it in 2000.

    Thanks,

    Howard

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Decompile puts everything into an uncompiled state. Then when you compact and repair, the database is reduced as much as it can be in size. When you reopen the database and compile the project, it will grow a bit as it recompiles everything, but you will have jettisoned some oddness that might have crept into you app. In Access 2000, especially, projects tended to get partially decompiled, which meant you couldn't really compile them and they weren't every really compiled. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> For 2000, decompile became a real necessity.
    Charlotte

  10. #10
    Lounger
    Join Date
    Oct 2002
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    Thanks Charlotte - I have 2000, and have one db with a very large number of coded forms, and modules. Users have experienced record corruption at times, and it seems to be getitng to be a more frequent occurrence. One site has 30+ simultaneous users. Perhaps decompiling will help this out - I'm sure it won't hurt.

    Thanks for always sharing so much information.

    Regards,

    Howard

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compacting resets 'Modified' and 'Created' details (2000)

    It was not clear to me whether you know how to decompile a database. The best way is to create a right-click option for .mdb files in Windows Explorer.

    In Windows Explorer, select Tools | Folder Options...
    Locate and select .mdb (Microsoft Access Database)
    Click Edit... (in Windows XP, click Advanced...)
    Click New...
    Type Decompile in the Action box.
    In the second box, enter "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" /Decompile "%1"
    (you should use the path to MSACCESS.EXE on your PC)
    Confirm until you're back in Explorer.
    You can now right-click an .mdb file and decompile it. After that, open the database, switch to the Visual Basic Editor, and compile the code (Debug menu). Switch back to Access and do a Compact and Repair.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •