Results 1 to 3 of 3
  1. #1
    SMcD is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Posts
    1

    Impact of field size in linked tables


    Hello,
    My company uses an Access database that is split into a front and back end. It always seems to take a long time to load and create/export reports. Would limiting the field sizes of tables in the back end make queries run faster at all? There is currently no limit set for any of the fields. The current size of the back end is around 25,000KB. Also, if I reduce the field size too much for any data currently contained in a column, will that delete the entire row of data, or just the information in that column for that specific row?

    Thank you!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I think numeric data takes less space than alpha. Just defining a field as a number type sets some limits. Surely you have some number type fields?

    However, doubtful you will see much change in speed performance. 25MB is not really that big. My largest db is 156MB and that really isn't very big in the db world.

    Changing a field datatype could result in loss of data in that field, does not delete record.
    Last edited by June7; 06-20-2022 at 08:26 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Slow performance is usually down to poor design - non normalised data and lack of indexing being top of the list. 25mb is really very small, representing about 1% of the available capacity of access.

    Could be your code has been padded to do lots of unnecessary things

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

Similar Threads

  1. Replies: 2
    Last Post: 08-26-2017, 07:51 AM
  2. Impact of Windows 10 on Access 7
    By Peter Murray in forum Access
    Replies: 5
    Last Post: 09-15-2015, 02:10 AM
  3. Access table linked to excel - field size problem
    By tzmyo in forum Import/Export Data
    Replies: 1
    Last Post: 10-02-2013, 01:03 AM
  4. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  5. Replies: 5
    Last Post: 06-13-2012, 09:34 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