+ Reply to Thread
Results 1 to 2 of 2

Date accessed attribute wrong

Hybrid View

gazandwiz Date accessed attribute wrong 10-22-2008, 05:09 AM
gazandwiz Solved 10-23-2008, 12:22 PM
  1. #1
    Registered User
    Join Date
    10-22-2008
    Location
    England
    Posts
    2

    Date accessed attribute wrong

    This one has me baffled. If I save an Excel file the date accessed and the date modified attributes default to 03/01/2006. If I reset the attributes using a third party program to current date and time, the aforementioned attributes will revert to 03/01/2006 when I resave.
    Now if you think that's odd, it only happens on one drive, a networked drive that has mapped folders to drive letters. If I save the files on any other drive on my pc the attributes are correct. Access does the same wierd thing.

    I expect you'll suggest it's the drive. However, Word, Publisher and Powerpoint don't do this. If I use another PC to open an excel file, it too will not correctlly apply the attributes, as seen in windows explorer.

    I have deleted the folder, recreated it, copied files over with the correct date and time accessed and changed attributes, only to be resaved as 03/01/2006.
    Then I tried deleting the folder and creating a new .xls from scratch and saving it in a folder, created by Excel, on the networked drive. Guess what? The date was 03/01/2006.

    Any ideas anyone?
    Last edited by VBA Noob; 10-23-2008 at 12:42 PM.

  2. #2
    Registered User
    Join Date
    10-22-2008
    Location
    England
    Posts
    2

    Thumbs up Solved

    The problem was with the date and time on the NAS box. Why this only affected Excel and Access and not the other office suite components, I have no idea.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1