Long time to save or open a form

[SS]

hi all

I have a problem when opening a form or save the code behind . I am using
Access XP with Windows XP on machine P4 3.4 GHz, 1.5 GB RAM the problem is
that access take too much time to save or to open a form ,any idea to solve
this problem is appreciated

thanks in advance

Wael

 

[Tom Wickerath]

Hi Wael,

Is there a network that separates your computer from the actual .mdb file?
If so, my advice is to only do design changes on a local copy.

You might also try the undocumented /decompile switch. First, make a backup
copy of your database, just in case something horribly wrong happens. With
Access closed, click on Start > Run, and enter the following command:

msaccess /decompile

Note: If you have more than one version of Access installed, this command
will start the first version found in the search path. In that case, create
yourself a shortcut with a target that includes the full path to msaccess,
surrounded in doublequotes, along with the /decompile switch. For example:

Shortcut Target:
"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" /decompile

Navigate to your database. Hold the Shift key down the entire time that it
is starting. Once you see the database window, you can release the Shift
button. Do a compact and repair, while holding down the Shft key again:

Tools | Database Utilities | Compact and repair database

or, if this is Access 2007:
Office Button thingy | Manage | Compact and repair

Finally, open any code module and recompile your code:

Tap <Alt><F11>
Click on Debug | Compile ProjectName

where ProjectName is the name of your VBA project. Does this help
performance at all?

Note: If this is slow performance opening a form, especially if a network is
involved, but it does not involve design changes, then you may simply have a
non-optimal design. In other words, don't open a form bound to hundreds of
records. A golden rule is to only fetch the data actually needed. If this
applies, then take a look for additional suggestions in my Multi-User
Applications paper, available here:

http://www.accessmvp.com/TWickerath/

This includes disabling Name Autocorrect, setting all table subdatasheets to
[None], establishing a persistent connection, indexing fields appropriately,
and even using the JETShowPlan registry setting to check for table scans on
large tables.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[SS]

Hi Tom,

Disabling Name Autocorrect solved the problem .

thanks a lot,

Wael

Hi Wael,

Is there a network that separates your computer from the actual .mdb file?
If so, my advice is to only do design changes on a local copy.

You might also try the undocumented /decompile switch. First, make a
backup
copy of your database, just in case something horribly wrong happens. With
Access closed, click on Start > Run, and enter the following command:

msaccess /decompile

Note: If you have more than one version of Access installed, this command
will start the first version found in the search path. In that case,
create
yourself a shortcut with a target that includes the full path to msaccess,
surrounded in doublequotes, along with the /decompile switch. For example:

Shortcut Target:
"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" /decompile

Navigate to your database. Hold the Shift key down the entire time that it
is starting. Once you see the database window, you can release the Shift
button. Do a compact and repair, while holding down the Shft key again:

Tools | Database Utilities | Compact and repair database

or, if this is Access 2007:
Office Button thingy | Manage | Compact and repair

Finally, open any code module and recompile your code:

Tap <Alt><F11>
Click on Debug | Compile ProjectName

where ProjectName is the name of your VBA project. Does this help
performance at all?

Note: If this is slow performance opening a form, especially if a network
is
involved, but it does not involve design changes, then you may simply have
a
non-optimal design. In other words, don't open a form bound to hundreds of
records. A golden rule is to only fetch the data actually needed. If this
applies, then take a look for additional suggestions in my Multi-User
Applications paper, available here:

http://www.accessmvp.com/TWickerath/

This includes disabling Name Autocorrect, setting all table subdatasheets
to
[None], establishing a persistent connection, indexing fields
appropriately,
and even using the JETShowPlan registry setting to check for table scans
on
large tables.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

hi all

I have a problem when opening a form or save the code behind . I am using
Access XP with Windows XP on machine P4 3.4 GHz, 1.5 GB RAM the problem
is
that access take too much time to save or to open a form ,any idea to
solve
this problem is appreciated

thanks in advance

Wael

 

[Tom Wickerath]

Name Autocorrect (or should I say Name Autocorrupt) strikes again! <smile>

Glad to read that you found a resolution.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________