Results 1 to 3 of 3
  1. #1
    ser01 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    64

    Performance of ACCDB vs. ACCDR


    I recently started pushing FE updates to my user with the DB in the ACCDR format. I started doing this mainly because I want to have rigid control over what my users can or can not do. I have noticed however that my queries run a little faster. I have a few queries that use data from 3 different tables. One of those tables has over 80,000 records and growing at a pace of about 5000 records a month. Since my tables in my BE are residing on a server on the network running the queries can be a little slow.
    Can anybody confirm that the ACCDR is faster than the ACCDB? Also any other tips on improving the speed of my queries would be greatly appreciated.

  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

  3. #3
    ser01 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    64
    Quote Originally Posted by RuralGuy View Post
    Thank you very much for that link, looks like a great read!

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

Similar Threads

  1. external accdb won't unlock
    By taxidev in forum Programming
    Replies: 4
    Last Post: 06-07-2011, 11:53 AM
  2. converting mdb to accdb format
    By crowegreg in forum Access
    Replies: 1
    Last Post: 05-31-2011, 10:34 AM
  3. cannot change extension from accdb to accdr
    By everette in forum Access
    Replies: 4
    Last Post: 05-01-2011, 03:47 AM
  4. Accdb file differences running xp or Win7
    By 123seven in forum Access
    Replies: 1
    Last Post: 04-24-2011, 10:45 AM
  5. Linking accdb to Outlook Contacts folder
    By Craig in forum Import/Export Data
    Replies: 1
    Last Post: 02-14-2011, 05:51 PM

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