Slow Load Time

Dec 5, 2006

Hello all,
I have a continuous form that is slow on loading a portion of the code. The form is designed to pull students who need to be either warned or terminated based off of their GPA. Below is the code that is delayed in being displayed on the form:

Public Function warnOrTerminate(creditAttempt As Integer, GPA As Double)
' these numbers are from the "satisfactory progress" portion of the catalog

'warning if the following is true
'GPA<1.5 and ([cAttempt]<=15)
'GPA<1.9 and ([cAttempt]>=16 and [cAttempt]<=30)
'GPA<2.2 and ([cAttempt]>=31 and [cAttempt]<=45)
'GPA<=2.4 and ([cAttempt]>=46)

'terminate if the following is true
'GPA<1 and ([cAttempt]<=15)
'GPA<1.5 and ([cAttempt]>=16 and [cAttempt]<=30)
'GPA<1.75 and ([cAttempt]>=31 and [cAttempt]<=45)
'GPA<=2 and ([cAttempt]>=46)

Select Case creditAttempt
Case Is <= 15
If GPA < 1 Then
warnOrTerminate = "Terminate (1.0)"
ElseIf GPA < 1.5 Then
warnOrTerminate = "Warning (1.5)"
End If

Case 16 To 30
If GPA < 1.5 Then
warnOrTerminate = "Terminate (1.5)"
ElseIf GPA < 1.9 Then
warnOrTerminate = "Warning (1.9)"
End If

Case 31 To 45
If GPA < 1.75 Then
warnOrTerminate = "Terminate (1.75)"
ElseIf GPA < 2.2 Then
warnOrTerminate = "Warning (2.2)"
End If

Case Is >= 46
If GPA < 2 Then
warnOrTerminate = "Terminate (2.0)"
ElseIf GPA < 2.4 Then
warnOrTerminate = "Warning (2.4)"
End If

End Select

Everything works fine - but the field that shows the end user to either warn or terminate the student shows up very delayed. Any thoughts or ideas on speeding this up??

View Replies


ADVERTISEMENT

Access Slow To Load [really Really Slow!]

Dec 14, 2007

Hi All,

I'm having trouble with access. Basically it has been very slow to load
(over 30 seconds when not opening a database) and when opening a database it just crashes.

Has anyone any idea what could cause this as it worked fine before ?

also would a reinstall help ??

-Elfman

View 3 Replies View Related

Forms :: Recordsource - Slow Form Load Event

Mar 9, 2013

I've got a DB, which has 3 forms ( all 'under' 3 navigation buttons/tabs ). The main form ( Client's form ) is set to show first, and currently has a recordsource of about 1350 records. I think the size of the recordsource, and the fact it 'loads' the other two forms all 'in one go', is slowing it down ( between 5 and 10 secs. to load ).

I read I should set the Visible properties of forms, not shown immediately, to false, only setting them to True in the On_Load event - when Tab is selected. Ideal I thought. However, I can't find this property in the Form's property sheet.

View 1 Replies View Related

Cannot Load Post From A Specific Date And Time.

Dec 11, 2005

Hi, i cannot load posts from a specified date and time



PostDate = now()

'AID = accountID of the poster

'read post after added into DB
Set rsForum = Server.CreateObject("ADODB.Recordset")
strForumSQL = "Select * From tblPost where tblPost.PostDate = '"&PostDate&"' and tblPost.PostBy = "&AID&""
rsForum.Open strForumSQL, strForumCon,3,3
PostID = rsForum("PostID")


I gets an error when posting messages, i think is because: tblPost.PostDate = '"&PostDate&"'

PostDate is no text field, its a Date field and i tried to use this symbol: ' around postdate, i also tried to not use it, but then i gets another error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tblPost.PostDate = 12/11/2005 10:32:50 AM and tblPost.PostBy = 6'.

but that is because the date/time format uses spaces.
How can i fix this?

Thanks in advance

View 4 Replies View Related

Time Format - Short Time Displayed As Medium Time

May 23, 2006

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.

The link works fine but the time formats are different.

On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format

However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#

Weirdly though, when you just open the table, the times are in the correct shorttime format.

Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?

Any ideas?

This screen shot may help:

View 2 Replies View Related

Time Format - Short Time Displayed As Medium Time

May 23, 2006

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.

The link works fine but the time formats are different.

On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format

However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time.

Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?

Any ideas?

View 1 Replies View Related

Very Slow DB

Nov 8, 2006

Hi,

My DB is very slow when it's used by more than 1 person at a time. It's divided into FE/BE. The BE is in a shared server and a copy of the FE is in each person's machine.

I don't know why it takes ages to respond. Any help will be very much appreciated.

Regards,
B

View 8 Replies View Related

Why Is Split Db So Slow?

Apr 29, 2005

Hi all

I have an Access 2003 db that works extremely well as a stand-alone application but I am keen to “split” it so that many users can operate it together.

Accordingly I did the split and placed the tables on our server, and tried running the front end locally.

Much to my horror, it takes about a minute to open, and many seconds to do anything after a button press etc.

I have been testing it on my wireless home network and the same thing happens, except now I can monitor network activity from the “network working” light.

What I see baffles me and would welcome comments, in particular, what I can do to speed it up by a factor of 100!

1.It takes forms about 50 seconds to open; however, this is due to about 40 seconds of network activity BEFORE the form’s load event fires!
2.In DESIGN mode, any minor change to a control for example, results in about 40 seconds network activity.
3.All queries upon which forms are based take well under a second to run over the network.
4.Making an mde file has no effect.

I thought the idea of splitting was to keep the forms/queries/code etc, local to a machine so I don’t understand what all the network activity is about, particularly in design mode. Also, given the actual queries are so fast, just what is Access doing??

Any comments please?

Skeletal

View 3 Replies View Related

Slow Subform

Jun 2, 2005

I have a form with a subform (there is no child parent relationship) , when I open the mainform it causes the subform to slow down.

ie If I open the suform by itself - it opens quickly
If I then open the main - it runs quickly

If I then open the main again it runs slow or if I open the subform again - it runs slow - it continues to run slow - until I have opened the sunform by itself.

So something in the mainform is causing the subform to slow down.

Help! Thanks

View 2 Replies View Related

Slow Running

Jun 24, 2005

I am using Access 2003 but it is to slow, what can I do?

View 1 Replies View Related

Slow Database? HELP!

Apr 4, 2006

Hi,

I have a database for booking equipment in and out.

I have the backend stored on a shared drive on our LAN, and the front end on each client machine.

The database has been working fine until just now, it runs very slow and my DCount functions have stopped displaying data.

I have no idea why this has happened, please help?

View 1 Replies View Related

Slow Connection

Aug 24, 2006

hi all,

i'm create a aplication in ms access 2000 developer edition. this app comunicate with sql 2000.

we have problem with slow connection provided by access. in headquater wher people use access app it working quickly. sql 2000 is localted at headquarter too. but if i run app in warehouse it working very slowly.

VPN connection doesn't slow. but access can't use all vpn connection capacity but only 1/5 from this capacity?

how can i do something that acces can use all capacity that i have?

example: link is 512 kbps but access use only 100kbps and work very slowly.

View 1 Replies View Related

VPN - Process Are Too Slow!

May 30, 2007

I developed a sales database that contains around twenty forms, (in addition to tables, queries, reports and 2 modules). In these forms, I'm setting recordsets, select statements and filters. We recently hired a person to set up a Virtual Private Network. After spending a couple of thousands on a server and countless hours reprogramming the database to have multiple users access the database out in the field, (via Verizon broadband network card), we were unsuccessful to use the database since it was taking too long to download the data or perform any calculations. The database is split. The users have a front end.

The person setting the VPN has suggested that I get rid of all the queries that I have in the forms (which is impossible), or use Visual Basic for the front end instead of Access with VBA.

When I set up the recordsets I use the following setting:
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic

I don't know what to do. This program is very complicated and I don't want to have to reprogram the whole thing with Visual Basic, and I don't know how the front end is going to work if I eliminate all the queries, select statements and filtering.

Any ideas, comments or suggestions would be appreciated.

Maritza

View 2 Replies View Related

Text Box With Nz() Very Slow

Feb 25, 2008

At the moment, I have a very simple Access 2007 database with 3 small tables, and 4 small forms.

In two of the forms' headers, I have a text box with contents '=Nz([FirstName] & " " & [MiddleName] & " " & [LastName],"Untitled")' which I took from Microsoft's Marketing Projects sample database.

When I open the two forms with this text box, the forms displays instantaneously except for this text box -- this text box doesn't show its contents for almost a full second. The part of the form that displays right away includes the fields FirstName, MiddleName, and LastName, so it's not that Access is taking forever to pull the row of data...

The database isn't too large. It's about 800K.

It isn't the computer, it's an Intel Core2 Duo E6600 with 4GB memory.

Any ideas on how to speed this up? Is there a totally different way I should be doing this?


As you can problaby tell, I'm relatively new to Access. I've read a few books, but am at a loss why this function is running so slowly. Before, I've focused on web development however this client requres Access for this project. Any help would be much appreciated!

View 14 Replies View Related

Slow To Open

Apr 22, 2005

I have a very simple table with about 20 fields. The thing is it has about 360,000 records in it. It has always been a little slow to open, although using a query works pretty fast. There is just this one table, no forms, no reports, no saved queries. Simple database with one table, but it takes forever to open now, seems to have gotten worse. I have compacted and repaired many times and it does not help. The database is stored on a server.

When I click to open the table up it says RUNNING QUERY at the bottom of the screen and then runs and runs for a LONG time. I cannot rely on queries since we want to keep this real simple for users of this data. Just go in, do a FIND or a FILTER and that is it.

Any idea why this is running so slow, or why it says RUNNING QUERY when I attempt to open it, is that normal?

Thanks.

View 5 Replies View Related

Is Tab Form Very Slow

Dec 6, 2005

Hello All,
Yesterday only i designed my first form in VB.I designed a tab form as i have to place two kinds for data from the same table separately (for user convience).i was succesfull in that.But the problem is the form is very slow to load........very very slow......

i want to know whether Tab form are slow or i have made any mistake..

any solution please.....

View 1 Replies View Related

Slow Updates

Sep 13, 2005

I have a project that produces a roll report. To do this, I have two tables:

T1 (roughly 20,000 records)
ID (Primary Key), PrevAmt, CurrAmt, Action

T2 (roughly 40,000 records)
ID, Amt (linked Excel spreadsheet)

I then run 4 queries in sequence

Q1: Update T1 set PrevAmt=CurrAmt, CurrAmt=0;
Q2: INSERT INTO T1 (ID, PrevAmt, CurrAmt) SELECT ID, 0, 0 FROM T2; /* keys that already exists will fail to insert)*/
Q3: Update T1 INNER JOIN T2 ON T1.ID = T2.ID SET T1.CurrAmt=T1.CurrAmt + T2.Amt;
Q4: Update T1 SET Action = iif(PrevAmt=0 and CurrAmt<>0,"NEW",iif(PrevAmt<>0 and CurrAmt=0,"DROPPED",iif(PrevAmt<>CurrAmt,"CHANGED","UNCHANGED")));

T1 and the queries is in an Access file on a network drive. T2 is a link to an Excel sheet on a network drive.

When I run the queries from a PC on the local LAN, it takes about 2 minutes to update. I consider that acceptible. But I now have to run it from a PC attached to the network via a VPN over a somewhat slow DSL line. The queries take over 20 minutes to run. I want to cut that time down. But the Access file and the Excel file need to stay put as other users use them for other purposes. (Though they know not to access them till after they see my roll report in their in-box.)

What can I do to decrease the update time on this?

Thanks,
David

View 2 Replies View Related

Slow Network Database

Feb 7, 2006

This problem is driving me nuts!!
I`ve just spent a fair few months creating a database to be used by our sales team, I`ve about finished it and came to trial it with the sales manager. When he is using the database at the same time as me it becomes slow.
The design has a front end with all the queries, forms etc and a back end on a server containing the tables.
The database was created using Access 2000 and was designed to replace a similair db created on 97 which has a decent speed on the network.
The other strange thing is that one particular macro that I`ve been using for the speed tests runs quite slow (about 3 secs) when 2 pcs have the db open but once the macro has run if it is run again it takes typically less than a second to run.
What would cause a db to run a macro at different speeds after they`ve been run once? I`ve tried everything I can find on the net to try and improve the speed to no avail.
Help please!!

View 2 Replies View Related

MS Access Database Is Slow

Sep 16, 2006

Hi everybody,
I have an access database which is around 40 MB after compacting it and I feel that it is slow especially when I open cross table form. Is there any way to speedup the databse.
Note: my databse is on the share drive in my work.

View 1 Replies View Related

DB Runs Slow Over Network

Sep 18, 2006

I have a 16Mb DB. The intention is for users to access this over the network without copying onto their local machines.

At present, many of the forms are located on 1 master form and they are all subforms on tabs. There are a lot of calculated control boxes on the forms, and these seem to be very slow to bring back the data over the network whereas on my local machine, the data is displayed in a couple of seconds.

COuld this be sped up somehow? Maybe using queries or other methods?

View 12 Replies View Related

Slow Access Response

Oct 10, 2006

Hi

I have developed a DB for work and it has grown, it is about 60Meg, all of a sudden when I am opening Design View in Reports, or queries it started running really slow.

I always Compact on Close
I have Split the DB.

Still no Joy, I have a brand new Dell PC so nothing wrong there.

What is happening? it is a nightmare to get anything done.

Please advise.

H

View 3 Replies View Related

Access Initially Slow...

Aug 15, 2007

Hi Guys,

I've been searching for an answer for a long time, but i have a database with approx 100 forms, 100 tables (most linked to SQL Server) only a small proportion are front end tables, 50 or so queries, 20 or so modules.

Anyway the problem is, is that the database is slow, to open and to develop in, i have a decent system to develop on with a 3GHz CPU and 1 GHz RAM, but i dont get this problem with any of the other access databases i deal with.

It's kind of a lagging effect, then once it has been written into memory it's quicker... but why would that be different between the systems, as most the systems i deal with are fairly similar in size and in complexity.

For example when loading the logon screen, which is a simple unbound form, it seems to lag, there is 1 combo box which has a front end table as its row source, like 6 records. Then a username and password text boxes which are not bound to anything. Why should this be lagging? After like 2/3 secs its then ok, once ive logged in and then go back to this logon screen its fine, so i think it has something to do with memory.

Anyone else had anything similar happen to them and did they do anything to minimise this lagging effect?

Any ideas or comments are welcome,

Thanks.

View 5 Replies View Related

Access Suddenly Slow Down

Nov 16, 2007

Hello,

My acccess (.mde) application suddenly slowed down. I have increased the size for some fields in some Tables. Is it could be the reason for this? Is there any way i can get the speed back.

Many thanks in advance..

Nitesha

View 4 Replies View Related

Database Response Slow

Nov 19, 2007

The database response is significantly slow when our application requests data over a network. Are there any settings to adjust network response? The network is connected via a T1 line.

According to information I've found online, our application is the front end to the database and the database sits open on the server.

View 1 Replies View Related

Database Slow To Open

Jan 17, 2008

I have two databases, one is much larger than the other, but both have the same start up code. The larger database opens quickly, but the smaller database takes forever. I tried compacting and repairing the front end and the back end of the database, but that did not help. Any ideas on how I can speed this up?

View 4 Replies View Related

Split Table, Now Slow?

Mar 9, 2006

Hi all

I was hoping to get a little advice as to my problem. I have a database with many, many reports, forms and queries. I wanted to split the database to secure the tables and important data. So I use the database splitter wizard and ever thing went just fine. So now my database1 looks into database1_be for all tables.

My problem is: my program now runs very slow. The slowest seems to be when I am adding a new record. I can live with the slowness of retrieving an existing record. I do not have a server nor can I afford one at this time, so currently I am running a peer-to-peer network with the database1_be located on one of my computers second hard drive.

Is there something I can do to help speed things up?
Thanks Enviva

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved