Results 1 to 3 of 3

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

  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360

    "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
    6,432
    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
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,477
    Maybe you would post your dB for analysis??
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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
  •  
Tech Forums: Microsoft Office Forums