Results 1 to 7 of 7
  1. #1
    SteveDurham is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    8

    ACCDR not recognised in runtime!


    On some new computers I have found that file extension accdr is not recognised even though runtime is installed.

    Changing extension to accde will open the file but some queries fail.

    Has something in Access changed? How do I cure the problem?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Shot in the dark, but make sure the extension is registered in Windows. Right click on the file and select Open with...
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    SteveDurham is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    8
    Quote Originally Posted by pbaldy View Post
    Shot in the dark, but make sure the extension is registered in Windows. Right click on the file and select Open with...
    I tried that but could find no ACCDR on the computer. I have had this problem on two new computers. Installing Access 2010 Runtime cures the problem. Looking into file associations for 2016 runtime in "Set Program Associations" there is no accdr!

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    From a Google search: Try renaming the file to .ACCDB. That should restore full functionality.

  5. #5
    SteveDurham is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    8
    It is a commercial application and I don't want to upset the customers. ACCDB might work but the file is a compiled ACCDE. On two new computers with Access Runtime 2016 the original ACCDR refused to open. One required to know what to open with but could not find anything which would open ACCDR. The other went to Downloads and asked to open or install, then did nothing. My 2016 Access runtime does not have ACCDR extension. Very strange!

  6. #6
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    From what I can get from a web search, an ACCDR file is just a renamed ACCDB file, and renaming it back to ACCDB will restore full editing capability.

    Check this link (one of many): http://pcsupport.about.com/od/fileex...accdr-file.htm

    What I am suggesting you try is to rename your ACCDR file back to ACCDB, then if you can open it and update it as normal, then you can recreate an ACCDE (not ACCDR). In my opinion, customers should be using ACCDE anyway, since it is more secure from a modification viewpoint.

  7. #7
    SteveDurham is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    8
    The file is an accde renamed to accdr. accdr is for the runtime and ought to be recocognised by the runtime.

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

Similar Threads

  1. .accdr won't open
    By merlin777 in forum Access
    Replies: 32
    Last Post: 09-27-2015, 12:04 PM
  2. ApplyFilter in ACCDR
    By Cedarguy in forum Access
    Replies: 5
    Last Post: 05-11-2015, 05:49 AM
  3. .accdr file issue
    By EdCanada in forum Access
    Replies: 20
    Last Post: 04-04-2014, 12:10 AM
  4. User Passwords not recognised in Access 2010
    By Philm in forum Programming
    Replies: 2
    Last Post: 05-09-2012, 08:06 AM
  5. Allow additions on .accdr
    By dougie in forum Forms
    Replies: 0
    Last Post: 02-20-2012, 05: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