By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Access 2007 form question

P: n/a
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?
Aug 20 '08 #1
Share this Question
Share on Google+
7 Replies


P: n/a
"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


Aug 21 '08 #2

P: n/a
On Aug 20, 8:45*pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
"Icarus" <tjmos...@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
pleaseNOOSpamKal...@msn.com
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.
Aug 21 '08 #3

P: n/a
Icarus wrote:
On Aug 20, 8:45 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
>>"Icarus" <tjmos...@gmail.comwrote 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
pleaseNOOSpamKal...@msn.com


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?
Aug 21 '08 #4

P: n/a
On Aug 20, 9:43*pm, Salad <o...@vinegar.comwrote:
Icarus wrote:
On Aug 20, 8:45 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
>"Icarus" <tjmos...@gmail.comwrote 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
pleaseNOOSpamKal...@msn.com
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?
Aug 21 '08 #5

P: n/a
Icarus wrote:
On Aug 20, 9:43 pm, Salad <o...@vinegar.comwrote:
>>Icarus wrote:
>>>On Aug 20, 8:45 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
>>>>"Icarus" <tjmos...@gmail.comwrote 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
pleaseNOOSpamKal...@msn.com
>>>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.
Aug 21 '08 #6

P: n/a
On Aug 21, 12:18*pm, Salad <o...@vinegar.comwrote:
Icarus wrote:
On Aug 20, 9:43 pm, Salad <o...@vinegar.comwrote:
>Icarus wrote:
>>On Aug 20, 8:45 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
>>>"Icarus" <tjmos...@gmail.comwrote 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
pleaseNOOSpamKal...@msn.com
>>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?
Aug 22 '08 #7

P: n/a
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

Aug 23 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.