Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Apr 2011
    Posts
    99
    Thanks
    5
    Thanked 18 Times in 17 Posts

    Access 2010 "auto-repair" feature?

    Customer has multiple databases that open without noise in Access 2007. But opening the same databases in Access 2010 fires up a repair before it will actually open the database. I haven't seen anything that tells exactly what it's repairing.

    I'd like to find out more about this feature. What might be triggering it? Does the database really need repair? Is this configurable?

  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Does the issue happen on multiple PCs with 2010 or just one PC?

    It would help to know:
    Are the databases split?
    Are the front ends on the local hard drive?
    Are the database in a trusted location?
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    Star Lounger
    Join Date
    Apr 2011
    Posts
    99
    Thanks
    5
    Thanked 18 Times in 17 Posts
    1. I'll ask them to check.
    2. Don't know if the databases are split. I'll ask.
    3. Everything is on the local hard drive.
    4. I assume if it's on the local drive, it's trusted.

  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Quote Originally Posted by riffraff View Post
    4. I assume if it's on the local drive, it's trusted.
    Um ... not a good assumption.

    By default nothing is trusted. Every folder and/or file must be explicitly trusted. This can be done manually or by executing trusted code. It is also by user profile not Window instance. Once a folder is trusted for a specific user then any file added to that folder will also be considered as trusted.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

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