Results 1 to 2 of 2
  1. #1
    ggarza75 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    2

    Slow Search

    Good afternoon all.



    I been on the job for about a year and nine months. I inherited an Access project (.apd) file that users use as a front end to our SQL database.

    This file was created pre-Access 2003, but in Access 2003, the file works just fine and dandy. This file has many forms, reports, macros, and modules. The queries and tables are get pulled in from the SQL database.

    However, network admin wants everyone to upgrade to Access 2007.

    My users have found that when they open up a form, the data populates a little longer than when it did in Access 2003. Not long but it's noticeable. However, when a user does a simple FIND (CTRL+F) on a column, say VendorID, it takes forever for the result to come back or Access 2007 locks up and crashes.

    Again, when a user does the same process in Access 2003, the results come back quick and never locks up.

    My attempt to resolve this issue was this:
    **Create a new adp file in Access 2007 and then import the objects I need from Access 2003. Result: Did not work.

    Is there a way to resolve this issue?

    So for now, everyone is back on Access 2003 so they can work like before.

    Thanks and hope some someone can guide me to an answer.

  2. #2
    ggarza75 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    2
    I resolved my own issue!!!

    Originally, the form used a VIEW to populate the data. So after reviewing other forms that work similar as my issue form, I changed the form to use a Select statement instead of a VIEW. After that change, eveything worked great.

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

Similar Threads

  1. Very Slow Calculated Field
    By SteveW in forum Access
    Replies: 4
    Last Post: 11-21-2010, 09:50 AM
  2. Retrieve Data Too Slow
    By BGF in forum Programming
    Replies: 8
    Last Post: 09-08-2010, 04:28 PM
  3. Replies: 2
    Last Post: 08-31-2010, 08:57 PM
  4. slow performance with multiple users
    By netgrim in forum Access
    Replies: 4
    Last Post: 05-16-2010, 05:41 PM
  5. Slow Database Response
    By Nixx1401 in forum Access
    Replies: 3
    Last Post: 02-25-2010, 11:09 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