Access 2007 form question

[Icarus]

I have a Access 2000 database that I am opening with Access 2007.

When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.

In Access 2007 my main form opens, a form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.

Has anyone come across this before, and if so were you able to fix it?

[Albert D. Kallal]

"Icarus" <tj******@gmail.comwrote in message
news:6d**********************************@z72g2000 hsb.googlegroups.com...

>I have a Access 2000 database that I am opening with Access 2007.

When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.

In Access 2007 my main form opens, a form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.

Has anyone come across this before, and if so were you able to fix it?

You not given much details such as if there is a network involved, or your
application is multi-user and split.

I would work your way thought the following list of things to check however:

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

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

[Icarus]

On Aug 20, 8:45*pm, "Albert D. Kallal" <[e-mail]>
wrote:

"Icarus" <[e-mail] in message

news:6d**********************************@z72g2000 hsb.googlegroups.com...

I have a Access 2000 database that I am opening with Access 2007.

When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.

In Access 2007 my main form opens, a form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.

Has anyone come across this before, and if so were you able to fix it?

You not given much details such as if there is a network involved, or your
application is multi-user and split.

I would work your way thought the following list of things to check however:

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

--
Albert D. Kallal * *(Access MVP)
Edmonton, Alberta Canada
[e-mail]

it is a multi user, where there is a client on each user's c:\ drive,
but they all hit against the same back end database.

The form is opened with a docmd.openform, but there is a Form_Open on
the form itself that processes as the form opens. It makes it through
the whole Form_Open code, all the way to the "Exit Sub", but then
freezes up before it gets back to the original function.

When I go line by line with F8 with the exact same database, but
opened with Access 2003, it makes it back to the original function
that calls the form, but the process freezes when the database is
opened in Access 2007.

[Salad]

Icarus wrote:

On Aug 20, 8:45 pm, "Albert D. Kallal" <[e-mail]>
wrote:

>>"Icarus" <[e-mail] in message

news:6d**********************************@z72g20 00hsb.googlegroups.com...

>>>I have a Access 2000 database that I am opening with Access 2007.

>>>When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.

>>>In Access 2007 my main form opens, a form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.

>>>Has anyone come across this before, and if so were you able to fix it?

You not given much details such as if there is a network involved, or your
application is multi-user and split.

I would work your way thought the following list of things to check however:

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

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
[e-mail]

it is a multi user, where there is a client on each user's c:\ drive,
but they all hit against the same back end database.

The form is opened with a docmd.openform, but there is a Form_Open on
the form itself that processes as the form opens. It makes it through
the whole Form_Open code, all the way to the "Exit Sub", but then
freezes up before it gets back to the original function.

When I go line by line with F8 with the exact same database, but
opened with Access 2003, it makes it back to the original function
that calls the form, but the process freezes when the database is
opened in Access 2007.

Do you have the Office and Access service packs installed?

[Icarus]

On Aug 20, 9:43*pm, Salad <[e-mail]:

Icarus wrote:

On Aug 20, 8:45 pm, "Albert D. Kallal" <[e-mail]>
wrote:

>"Icarus" <[e-mail] in message

>news:6d**********************************@z72g200 0hsb.googlegroups.com....

>>I have a Access 2000 database that I am opening with Access 2007.

>>When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.

>>In Access 2007 my main form opens, a form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.

>>Has anyone come across this before, and if so were you able to fix it?

>You not given much details such as if there is a network involved, or your
application is multi-user and split.

>I would work your way thought the following list of things to check however:

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

>--
Albert D. Kallal * *(Access MVP)
Edmonton, Alberta Canada
[e-mail]

it is a multi user, where there is a client on each user's c:\ drive,
but they all hit against the same back end database.

The form is opened with a docmd.openform, but there is a Form_Open on
the form itself that processes as the form opens. *It makes it through
the whole Form_Open code, all the way to the "Exit Sub", but then
freezes up before it gets back to the original function.

When I go line by line with F8 with the exact same database, but
opened with Access 2003, it makes it back to the original function
that calls the form, but the process freezes when the database is
opened in Access 2007.

Do you have the Office and Access service packs installed?- Hide quoted text -

- Show quoted text -

I should. How do I double check this?

[Salad]

Icarus wrote:

On Aug 20, 9:43 pm, Salad <[e-mail]:

>>Icarus wrote:

>>>On Aug 20, 8:45 pm, "Albert D. Kallal" <[e-mail]>
wrote:

>>>>"Icarus" <[e-mail] in message

>>>>news:6d**********************************@z72g 2000hsb.googlegroups.com...

>>>>>I have a Access 2000 database that I am opening with Access 2007.

>>>>>When I open the datbase in Access 2000 or Access 2003, the database
>runs as expected.

>>>>>In Access 2007 my main form opens, a form with multiple tabs and
>subforms, the form now takes a "very" long time (more than 10 minutes)
>to load.

>>>>>Has anyone come across this before, and if so were you able to fix it?

>>>>You not given much details such as if there is a network involved, or your
application is multi-user and split.

>>>>I would work your way thought the following list of things to check however:

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

>>>>--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
[e-mail]

>>>it is a multi user, where there is a client on each user's c:\ drive,
but they all hit against the same back end database.

>>>The form is opened with a docmd.openform, but there is a Form_Open on
the form itself that processes as the form opens. It makes it through
the whole Form_Open code, all the way to the "Exit Sub", but then
freezes up before it gets back to the original function.

>>>When I go line by line with F8 with the exact same database, but
opened with Access 2003, it makes it back to the original function
that calls the form, but the process freezes when the database is
opened in Access 2007.

Do you have the Office and Access service packs installed?- Hide quoted text -

- Show quoted text -

I should. How do I double check this?

Don't know. In prior versions you went to Help/About.

[Icarus]

On Aug 21, 12:18*pm, Salad <[e-mail]:

Icarus wrote:

On Aug 20, 9:43 pm, Salad <[e-mail]:

>Icarus wrote:

>>On Aug 20, 8:45 pm, "Albert D. Kallal" <[e-mail]>
wrote:

>>>"Icarus" <[e-mail] in message

>>>news:6d**********************************@z72g2 000hsb.googlegroups.com...

>>>>I have a Access 2000 database that I am opening with Access 2007.

>>>>When I open the datbase in Access 2000 or Access 2003, the database
runs as expected.

>>>>In Access 2007 my main form opens, a form with multiple tabs and
subforms, the form now takes a "very" long time (more than 10 minutes)
to load.

>>>>Has anyone come across this before, and if so were you able to fix it?

>>>You not given much details such as if there is a network involved, oryour
application is multi-user and split.

>>>I would work your way thought the following list of things to check however:

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

>>>--
Albert D. Kallal * *(Access MVP)
Edmonton, Alberta Canada
[e-mail]

>>it is a multi user, where there is a client on each user's c:\ drive,
but they all hit against the same back end database.

>>The form is opened with a docmd.openform, but there is a Form_Open on
the form itself that processes as the form opens. *It makes it through
the whole Form_Open code, all the way to the "Exit Sub", but then
freezes up before it gets back to the original function.

>>When I go line by line with F8 with the exact same database, but
opened with Access 2003, it makes it back to the original function
that calls the form, but the process freezes when the database is
opened in Access 2007.

>Do you have the Office and Access service packs installed?- Hide quotedtext -

>- Show quoted text -

I should. *How do I double check this?

Don't know. *In prior versions you went to Help/About.- Hide quoted text -

- Show quoted text -

To open the form, I have the line: DoCmd.OpenForm "frmECD".

I've read somewhere that opening a form in Office 2007 as a dialog
form may cause problems. Does anyone know if by default, the line
above opens the form in dialog format?

[Linq Adams via AccessMonster.com]

That line will only open frmECD in Dialog mode if you have Dialog mode set in
its Properties sheet.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com