Results 1 to 4 of 4
  1. #1
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63

    rapidity of running

    my database has many record, so that when i running some commands for opening my report that source data is a query, the running speed is very low.


    how can i resolve this problem?
    Is the number of records affect to running of query rapidity?
    Is Visual Basic programming, a better way to manage large data banks?
    (i only Familiar with Visual Basic programming)

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Querys are generally better (faster).

    How many records and fields does your report require?


    Sent from my iPhone using Tapatalk

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722

  4. #4
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    I am sorry. My phone don't have any internet connection. I have account in Telegram and FaceBook in my pc.
    All of records in my database is about 73000.
    My report has a chart that chart contain 3 fields.

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

Similar Threads

  1. Running sum
    By dimkos in forum Queries
    Replies: 4
    Last Post: 12-11-2015, 08:37 AM
  2. Replies: 6
    Last Post: 09-14-2015, 06:05 PM
  3. Running Sum
    By BringTheR41n in forum Queries
    Replies: 2
    Last Post: 07-10-2014, 12:45 PM
  4. Running queries, VIA VB, but not running in Order
    By mike02 in forum Programming
    Replies: 6
    Last Post: 06-01-2013, 07:07 AM
  5. Running Sum
    By rpgowned in forum Queries
    Replies: 2
    Last Post: 08-30-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
  •  
Other Forums: Microsoft Office Forums