Vba – MS Access 2010 Report Design Very slow

ms-accessms-access-2010vba

I have a MS Access 2010 DB with bunch of forms,queries ,macros, Reports etc

The data for my report comes from ODBC links to SQL Server 2000 Tables via linked table property.

Now, whenever i goto design mode of a report,Everything moves painfully slow (I have to wait atleast half a minute for every mouse click,or to select a text box , or any operation performed on the report)

The report itself takes about a minute to run.Which i dont mind.

All I am looking for, is a quicker way to make changes to the design of reports.

Best Answer

This is an old question, but I had a similar issue with form design running extremely slowly recently. For me, only one form seemed to be affected (all others ran fine in design mode). The record source for the form was a complex query built on a hierarchy of subqueries. I dumped the query results into a table and used the table as the record source for the form instead of the query. This appears to have resolved the issue. Hope this helps someone else.

Related Solutions

Ms-access – Should I convert the Access 2002-2003 MDB to 2010 ACCDB

You have the option to keep your database in mdb and run it in Access 2010. In 80% of the cases it will run well with any change. If you have issues, there is a page:

http://allenbrowne.com/Access2007.html

and also a utility tool to test your database:

http://allenbrowne.com/AppIssueChecker.html

Take a look at both and you will see how you can solve your dilemma.

C# Outlook add-in get selected emails

I know it's a little late but this question ranks highly in search engines. Here is the solution I use to get selected emails in Outlook Interop:

internal static IEnumerable<MailItem> GetSelectedEmails()
{
     foreach (MailItem email in new Microsoft.Office.Interop.Outlook.Application().ActiveExplorer().Selection)
     {
          yield return email;
     }
}

Best Answer

Related Solutions

Ms-access – Should I convert the Access 2002-2003 MDB to 2010 ACCDB

C# Outlook add-in get selected emails

Related Topic