Topics Search

Slow Access Loading time

Slow Access Loading time
Views: 10
I am creating a system in access file size roughly 5mb, it is taking 5 minutes to load the complete system, any ideas on why this takes so long?how can I rectify this problem
Sponsored Links:

Similar posts...


How to specify UNC in Access 2003 BE

How to specify UNC in Access 2003 BE Icon
I have a FE and BE Access 2003 database and it is very slow even with only 2 or 3 users. I've tried "pre-loading" major forms and several other tricks nicely explained in several books, and this has, indeed, helped once the painfully slow pre-loading process has completed.

I usually go get a cup of coffee, and when I come back, my main menu has finally opened. Anyway, I just read a solution on here with great interest because it appeared to answer a related issue.

The answer in the related question was to use the "UNC" rather than a mapped directory to attach to the BE.

My question is how do I use UNC to map my BE files. When I use the Linked Table Manager, I specifically point to a mapped location for the BE Files. So how do I use the UNC to point my clients to the BE tables?

VBA loading errors on startup

VBA loading errors on startup Icon
I have a access 2000 .mdb database being run on windows 7, access 2010. I did not design this database program.

When the database is opened, this window pops up, and if YES is selected, another 7 follow; and then it repeats.
Microsoft Visual Basic for Applications:An error occurred while loading Form_frmReports, Do you want
to continue loading the project?

Access Query Slow

Access Query Slow Icon
I am having access table containing 35000 records and 30 columns, when I use query to select one record from that table, query execution takes so much time.

I have created an indexed field . Still execution is slow.

Access 2010 very slow with Sharepoint 2010

Access 2010 very slow with Sharepoint 2010 Icon
Working with access 2010 is so slow, every table to open (Sharepoint) and query (even in design mode) takes a long, long time.
what could this be?

Access 2007 Slow on Network and Locally

Access 2007 Slow on Network and Locally Icon
I have an access database that works like a charm as a single database on a local machine.

However, when I moved to a Server it was excruciatingly slow, and almost unusable. So, I split the database, thinking that would help, only to have it operate very slow there (as a local copy).

Any ideas on what I can do? Obviously, I do not have an impact to any server issues since they are ownded by IT department.

Loading my Outlook emails into Access

Loading my Outlook emails into Access Icon
How do I load my company emails from outlook into an Access Database. I have 8 years of emails that I tend to go back into but I need to save space on the server. My computer runs slow. I have about 20,000 emails and I can't go through them all to delete.
I am able to load the emails but not the attachments. Does anyone know how I can load them?

Access report design extremely slow

Access report design extremely slow Icon
I have an access report that is generated from 2 queries accessing a data table that gets up to a couple of million records in size. Running the report takes some time - probably around 15 minutes due to the size of the database and my slow computer.

I can cope with this however any change to the report design leaves me waiting an extreme amount of time to proceed with editing.

I'm guessing by the amount of disc activity taking place that the report design is actually running the queries in the background. Is there a way of turning off the querys while inreport design mode?

Form Loading Slow From the Shared Folder

Form Loading Slow From the Shared Folder Icon
I have a database that holds students information. The back-end is stored on a shared folder in a workgroup environment. The pictures of the students are stored externally on a folder in the same share folder as the backend. The front ends are installed on 4 computers. The current event of the form looks into the folder in the shared folder to display the picture associated with each record. This causes the form to load up very slow. what can I do to speed this up. The code to display the images is:

strFullPath = "\\ComputerName\Database\Students\" & Me.txtStudentID & ".bmp"

If Dir(strFullPath) = "" Then
Forms!frmUpdateEnrollment.txtImage.Picture = ""
Forms!frmUpdateEnrollment.txtImage.Picture = strFullPath
End If

The pictures are displayed properly. It is just that navigation between the records are very slow, specially when the form is loaded for the first time. the sizes of the pictures are below 100Kb

Exports/Outputs Suddenly Very Slow

Exports/Outputs Suddenly Very Slow Icon
I have an Access 2010 database which has very suddenly become very slow when either exporting to excel or outputting reports. The two common places where this happens are below (this code hasn't been changed any time recently).

Example 1 - Printing labels to pdf:
DoCmd.OutputTo acOutputReport, gStrReportName, acFormatPDF, strPathAndFile
Example 2 - Exporting to excel:

64-bit with Access 2003

64-bit with Access 2003 Icon
I had previously been running Windows XP with my Access 2003 program modules, and with no problems. After recently purchasing a 64-bit computer with Windows 7, and then reloading my Office 2003 with my Access modules, I am finding the programs runs slower particularly when making calculations or when running queries within the program. Any reason for this? I even tried loading Office 2007 with the same slow results.