Results 1 to 3 of 3
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496

    "file not found" (with work-a-round)

    often, but not THAT often, when re-opening an ACCESS project, after having spent some time coding in it, I'll get an error: "File Not Found"...

    compact and repair usually doesn't work... but what does is:


    • from the error, I'll jump back into VB (preferably into the module that I had last been mucking with)
    • delete a sub / function (any sub / function ....doesn't seem to matter which one)
    • save
    • control Z it back
    • save
    • close (the ACCESS project)
    • re-open


    VIOLA ! (no error)

    not a "need to know", but would be a "nice to know"...
    What's going on? (and is there something that i could be doing preemptively?)

    as always, with thnx in advance,
    mark
    Last edited by markjkubicki; 06-20-2019 at 03:47 PM.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I don't get it. If you're opening a file from Access and you get file not found, how do you play with the code? That's the only way I can recall experiencing this - like when I've moved, renamed or deleted a file that I'm trying to open from Access window.

    BTW, a viola is a stringed instrument
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe you would post your dB for analysis??

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 12-12-2016, 12:26 AM
  2. Replies: 8
    Last Post: 10-29-2014, 04:51 AM
  3. Replies: 2
    Last Post: 09-29-2012, 11:22 PM
  4. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  5. "File Not Found" error
    By jgelpi16 in forum Programming
    Replies: 5
    Last Post: 04-21-2011, 10:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums