Results 1 to 4 of 4
  1. #1
    cadsvc is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    19

    Slow Database

    DB Definition:



    Using Access 2007

    4 linked tables to an internal SQL DB for the company

    DB has pictures attached to 2 tables in my Access DB.

    At my location only our Admin Assist and I can generate First Piece Inspection Reports quickly. We scan a barcode from the SQL report to generate my part specific report.

    Have set up Technicians as users.

    As a rule only 1 person is logged into the DB at a time since we save dates when the reports are printed and taken to the floor.

    I set the Technicians PC to link to the SQL DB the same as my laptop and the Admin's Desktop user permissions and ODBC connections.


    Problem(s)

    1. It takes approx 10 minutes for the Techs PC to display the report. Reports are less than 3 pages long.

    ( IDEA... I need to log in from the Tech's PC to see if it takes me 10 min to pull up a report using their hardware)

    2. I compressed the DB and pictures, copied them to another facilities server. uncompressed them, and ran the report. No problem.

    A permissioned user at the other facility says it takes 10 minutes to display the thame part number report. This user is also a user for the SQL DB


    PLEASE COMMENT:

    1. Could hardware memory be a factor?

    2. Any ideas appreciated.

  2. #2
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    Hi,
    There are reasons why my access database is slow?

  3. #3
    cadsvc is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    19
    I'll look at memory on slow machines Tuesday regarding RAM.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    "other facility "..... ??

    that raised a flag for me........is a WAN involved?

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

Similar Threads

  1. Replies: 2
    Last Post: 03-29-2012, 07:45 AM
  2. Slow Processing over Network
    By weasel7711 in forum Access
    Replies: 2
    Last Post: 05-04-2011, 09:01 AM
  3. Slow Search
    By ggarza75 in forum Forms
    Replies: 1
    Last Post: 02-18-2011, 09:04 AM
  4. Retrieve Data Too Slow
    By BGF in forum Programming
    Replies: 8
    Last Post: 09-08-2010, 04:28 PM
  5. Slow Database Response
    By Nixx1401 in forum Access
    Replies: 3
    Last Post: 02-25-2010, 11:09 AM

Tags for this Thread

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