Results 1 to 2 of 2
  1. #1
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78

    after migrating to sql server some forms running slowly

    after migrating to sql server one of my form that is a single form with several subforms on the tabs are running slowly. i checked query related to main form is running quickly. also before migrating to sql, running of this single form with subforms were okey. but now opening form takes times and navigating through records of this form is slow while speed of related row source of this form (query) is fast.

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,
    when using a lot of subforms, a lot of data has to be pulled from the database. Try removing the subforms and replace them with related forms you can show when clicking a button.

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

Similar Threads

  1. after migrating to sql server my query is running slow
    By masoud_sedighy in forum SQL Server
    Replies: 4
    Last Post: 09-19-2017, 06:27 AM
  2. Migrating tables to SQL Server
    By Joakim N in forum SQL Server
    Replies: 15
    Last Post: 04-14-2017, 03:09 PM
  3. Error when migrating Access database to SQL Server
    By AnneForumer in forum Import/Export Data
    Replies: 1
    Last Post: 11-18-2016, 10:24 PM
  4. Migrating Access to SQL Server using an ODBC
    By cbende2 in forum Tutorials
    Replies: 2
    Last Post: 07-06-2015, 06:44 AM
  5. Replies: 0
    Last Post: 12-01-2011, 10:23 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