Front end opens slow - only when copied?

[jonceramic]

Hi all,

I have a situation I can't find any old messages or web-help on.

I have a split database with a bizarre quirk. When I open up the
front-end file, the main form opens up fairly quickly (~2-3 seconds.)

If I copy my front end in Windows Explorer, the first time I open it,
it's 2-3 seconds also.

But, the _second_ time I open it, it takes something crazy like 20
seconds. Closing takes forever also. After that, it's always slow.

Does anyone have any ideas what's going on? It's driving me nuts.

I'm worried that the only reason I'm not making the original front-end
go slow is that I have users in it right now. So, I'm scared to copy
the slow file, give it to my users, and be stuck with slowness forever.

Anyone have any ideas on what's going on?

Thanks,

Jon
p.s. I've lurked in this group off and on for a decade now, and
recently I took my first formal Access classes and was able to jump
right in to the advanced ones and felt a litle bored at times. Thanks
everyone!

[jonceramic]

I should note that I've narrowed this to the form I open upon launching
Access. If I open holding the shift key, the database opens quickly to
the table of objects.

But, when I click my main menu form, that is what takes a long time to
open.

On a copy...
If I try the "first open" trick, using the shift key, the form opens up
quickly. Then, if I close the form, and reopen it, (without closing
the database), it is now slow again permanently.

On the original...
I can't get it to go slow.

I'm wondering if the locks of the other users having the database open
right now are saving me from ruining it somehow?

All I can say is, I'm very frustrated and worried!

Any help is appreciated.

Thanks,

Jon

jonceramic wrote:

Hi all,

I have a situation I can't find any old messages or web-help on.

I have a split database with a bizarre quirk. When I open up the
front-end file, the main form opens up fairly quickly (~2-3 seconds.)

If I copy my front end in Windows Explorer, the first time I open it,
it's 2-3 seconds also.

But, the _second_ time I open it, it takes something crazy like 20
seconds. Closing takes forever also. After that, it's always slow.

Does anyone have any ideas what's going on? It's driving me nuts.

I'm worried that the only reason I'm not making the original front-end
go slow is that I have users in it right now. So, I'm scared to copy
the slow file, give it to my users, and be stuck with slowness forever.

Anyone have any ideas on what's going on?

Thanks,

Jon
p.s. I've lurked in this group off and on for a decade now, and
recently I took my first formal Access classes and was able to jump
right in to the advanced ones and felt a litle bored at times. Thanks
everyone!

[Albert D. Kallal]

Try setting up a persistent connection. That usually fixes this problem.

That persistent connection trick along with many other tips is outlined
here:

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

work your way throught the above list....

And, also, do conciser *always* distribtiong a mde to each user...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com

[jonceramic]

Further update....

This occurs even when I open the form in design view, and is limited to
the form.

On the form I have multiple combo boxes and conditional formatting. I
have some scripts in a Module (not related to the form) that use an
ODBC link to an Oracle database, but I have those same scripts in other
databases, and I've checked with print.debug and msgboxs, and none of
those scripts are triggering.

jonceramic wrote:

I should note that I've narrowed this to the form I open upon launching
Access. If I open holding the shift key, the database opens quickly to
the table of objects.

But, when I click my main menu form, that is what takes a long time to
open.

On a copy...
If I try the "first open" trick, using the shift key, the form opens up
quickly. Then, if I close the form, and reopen it, (without closing
the database), it is now slow again permanently.

On the original...
I can't get it to go slow.

I'm wondering if the locks of the other users having the database open
right now are saving me from ruining it somehow?

All I can say is, I'm very frustrated and worried!

Any help is appreciated.

Thanks,

Jon

jonceramic wrote:

Hi all,

I have a situation I can't find any old messages or web-help on.

I have a split database with a bizarre quirk. When I open up the
front-end file, the main form opens up fairly quickly (~2-3 seconds.)

If I copy my front end in Windows Explorer, the first time I open it,
it's 2-3 seconds also.

But, the _second_ time I open it, it takes something crazy like 20
seconds. Closing takes forever also. After that, it's always slow.

Does anyone have any ideas what's going on? It's driving me nuts.

I'm worried that the only reason I'm not making the original front-end
go slow is that I have users in it right now. So, I'm scared to copy
the slow file, give it to my users, and be stuck with slowness forever.

Anyone have any ideas on what's going on?

Thanks,

Jon
p.s. I've lurked in this group off and on for a decade now, and
recently I took my first formal Access classes and was able to jump
right in to the advanced ones and felt a litle bored at times. Thanks
everyone!

[jonceramic]

Thanks, Sir!

In my case (Access 2003), I seem to have no problems with the
persistent connection issue. I always have an lbd.

Turns out, this was the first time I've had to turn off the Name
Autocorrect! After all of these years of reading that as a solution, I
had never had this as an issue myself and didn't think to try it. But,
sure enough, it works!

Jon

Albert D. Kallal wrote:

Try setting up a persistent connection. That usually fixes this problem.

That persistent connection trick along with many other tips is outlined
here:

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

work your way throught the above list....

And, also, do conciser *always* distribtiong a mde to each user...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com