Slow Access Loading time
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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?
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?
I have created an indexed field . Still execution is slow.
what could this be?
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.
strFullPath = "\\ComputerName\Database\Students\" & Me.txtStudentID & ".bmp"
If Dir(strFullPath) = "" Then
Forms!frmUpdateEnrollment.txtImage.Picture = ""
Forms!frmUpdateEnrollment.txtImage.Picture = strFullPath
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
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
I am able to load the emails but not the attachments. Does anyone know how I can load them?
Example 1 - Printing labels to pdf:
DoCmd.OutputTo acOutputReport, gStrReportName, acFormatPDF, strPathAndFile
Example 2 - Exporting to excel:
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?