Very slow form

[Robert C]

I have a form in my database which has a subform and a large number of controls on it. It has become very slow to load up and when I jump from form view to design view and back. Is this simply because there are lots of controls and is there any way ( apart from reducing the number of contols) that I can speed it up. There isn't a great amount of records at the moment and I'm worried it will slow down even more when the data builds up. I compact the database each time it closes.

Thanks for any help

 

[Peter D]

This could be a memory/disk swapping issue. How much memory does your computer have?

You can speed things up by creating an .mde file out of your database.

Are you using Windows 2000 SP1? I've heard about a few performance issues with it related to Access 2000.

I'm sure there are more things to check. These are just a few that come to mind.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools - http://www.peterssoftware.com

 

[Richie]

According to jet perfomance white paper creating an mde file has no noticeable improvement on form performance, another mistake in access help file? Do you have a lot of modules behind the form? If so remove them to standard modules and call them only when required.

 

[Robert C]

Ritchie

Thanks for your reply. Can you give a bit more detail on how I should change the modules. I don't have a lot of VBA knowledge. Most of the VBA on this form is based on the wizards or for code gleaned from forums like this one.

I'm afraid I need a bit more basic information.

Thanks for your help

Rob

 

[stuey]

Nice Insight guysa what I am looking to acertain is what is an acceptanble performance criteria where lookup fields are concerned mine is ratchety I only have one combo box two calculations and set of tabs on my form, it takes for seconds to load but the combo box takes around 2 seconds to repsond to key strokes.

It looks up a expression in a query I'm sure this is the problem but how else to you look up specifc records in a dataset, I tried two combo boxes which were based upon each other to little or no success?

any clues

Stuart

 

[stuey]

Focused even further I decided instead of doing this in my devlopment envioronment ( laptop 2 PC file sharing I would use the server and try it out, no difference, workstation perfomrm fine and laptop dismally by comparison, worse so when user is logged in on both machines.

so....

currently splitting the database between front and back end using the wizrd and going to try and run local forms etc and backend tables see where that gets me.

can anyone comment on issued surround record locking and autonumbering if you have two front ends working on one back end DB?

 

[stuey]

Okay finally similar performance from both machines connecting to a dedicated server.

or the other solution is if you use file and printer sharing on a machine(98/95, possibly ME dunno yet)

You can set the file system properties, by right hand clicking on my computer or going via the control panel,

Choose File system and set to network server, this will change (something) and your machines will perform better under access, ( read in a book somewhere too.

One simple question ( which I will probably answer is that somtimes people need to work at the machine which is being used as a server is there anywhay of quickly resetting the tables one copy of the database to being local ones, ( i suppose i could re-import the objects into the db_be.mdb and that would work

and also how do you update all the work stations quicly without using replication

More Feedbak anyone

Stuart