Results 1 to 8 of 8
  1. #1
    heynay01 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    9

    Access 2010 - Location memory?? And skipping blank reports??

    I upgraded to 2010 recently, so I wasn't aware of these issues when I built this database as they weren't issues in my older version.

    I built this database on my desktop. It is in a folder and has subfolders (30 in total) in the same folder, CVS files are dropped into the subfolders and then imported into tables. I moved the database folder (database and all subfolders) from my desktop to another location (like My Documents), and now it pops up with a message saying



    "...location\desktop\loss runs\policy30 refers to a location that is unavailable. It could be on a hard drive on this computer, or on a network. Check to make sure the disk is properly inserted, or that you are connected to the Internet or your network, and then try again. If it still cannot be located, the information might have been moved to a different location."

    So it seems like Access has some sort of memory that this is where the file was located, and no longer is. But when I import the information it still works correctly and imports the data. How do wipe this memory or get rid of these pop-ups - and it only does the pop-ups for some of the 30 folders, not all of them...

    My second question has to do with skipping blank reports. I have a report with 2 subreports in the footers, where the second subreport may or may not have data in it. I have to export the reports to rtf files, so I need to find code to ignore the blank subreport and stop it from producing a blank page (found code for earlier versions but it doesn't work for 2010 - fail).

    Any suggestions are greatly appreciated.
    Thanks!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You have not set your "Trusted Locations" yet. http://www.btabdevelopment.com/ts/de...aspx?PageId=13

  3. #3
    heynay01 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    9
    Adding the location to trusted locations didn't help any, I'm still getting the same pop-ups. I don't have my desktop as trusted location yet a copy of the DB on there doesn't produce the pop-ups.

    Any other ideas?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you exited Access and then relaunched Access?

  5. #5
    heynay01 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    9
    Yes, many times. I've been trying to resolve these issues for about a month now.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Did you include the SubFolders in the Trusted Location? Is this a split application FE/BE?

  7. #7
    heynay01 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    9
    Yep, subfolders are allowed and it's not a split application.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I've been doing some research to see if it is a known Vista issue. No luck there. How about reinstalling Access? I'm out of ideas when I say that.

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

Similar Threads

  1. Memory & Reports
    By houseofturner in forum Reports
    Replies: 3
    Last Post: 02-16-2011, 05:26 AM
  2. 2010 and 2007 Access Queries, Forms & Reports
    By rpaldridge in forum Import/Export Data
    Replies: 3
    Last Post: 02-11-2011, 07:37 AM
  3. 2010 Access reports
    By wthoffman in forum Reports
    Replies: 3
    Last Post: 10-12-2010, 09:36 AM
  4. Access 2007 Form Image Location
    By trb5016 in forum Access
    Replies: 0
    Last Post: 07-08-2010, 08:04 AM
  5. REPORTS BLANK PAGES/I can't remember
    By SpotoR1 in forum Reports
    Replies: 0
    Last Post: 03-03-2009, 07:28 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