Slower form when using full version rather than runtime version

  • Thread starter Thread starter Svein Engebretsen
  • Start date Start date
S

Svein Engebretsen

Two users (including myself) are running an mdb through the full version of
Access, while six other user are using the runtime version. A strange effect
is that those of us who are using the full version of Access opens a form in
about 5 minutes and 30 seconds, while the users using the runtime module,
needs less that a second to open it.

Any suggestions appreciated.

Thanks,

Svein
 
I'd try dropping in some logging code... so that a text file is written to
with the time the line was written. That way you should be able to identify
which code is causing the delay.
 
I suspect two things:

First, you did the right thing, and those runtime users get a mde...right?

If you have a mdb, then they can become un-complied, and further things like
track-name autocorrect come into play, and slow things down.

I also assume you are running a split database...right?

Anyway, check the track-name auto correct. Also, you need to keep a
persistent connection to the front end.

There is a list of things to check for performance here:

http://www.granite.ab.ca/access/performancefaq.htm
 
Back
Top