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:

More topics


How to specify UNC in Access 2003 BE

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

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

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

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?

Form Loading Slow From the Shared Folder

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

Access 2007 Slow on Network and Locally

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.

Slow performance (REALLY slow!)

My database performs incredibly slow, especially (but not only) in design mode. When I delete a text box from a form, it takes about 30 seconds. The db is compacted and I have a P4 2ghz 256k computer running XP pro.

There is User-level security on the db and I am accessing the db over a network. Nothing else is slow (including other network-based tasks).

Does anyone have any solutions or ideas for troubleshooting

Loading my Outlook emails into Access

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?

Exports/Outputs Suddenly Very Slow

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:

Access report design extremely slow

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?