Access 97 to 2002 problem

H

Harry J

When I try to save design changes that I made to a form,
a report, or a standard module. It takes longer to save
the object than it did in Microsoft Access 95 or 97.
Also the a form takes a long time to open in the current
version (Access 2002) which use to open quickly in the
old version (Access 97)
The database I am talking about is converted from Access
97 to Access 2002. when am getting error when I try to
make MDE file. What is the solution?
Please help me.
Harry
 
T

Tony Toews

Harry J said:
When I try to save design changes that I made to a form,
a report, or a standard module. It takes longer to save
the object than it did in Microsoft Access 95 or 97.
Also the a form takes a long time to open in the current
version (Access 2002) which use to open quickly in the
old version (Access 97)
The database I am talking about is converted from Access
97 to Access 2002.
Click to expand...

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
when am getting error when I try to
make MDE file. What is the solution?
Click to expand...

If A97 then Ctrl+G to open the debug window >> Debug >> Compile and
Save All Modules.
If A2000 or newer then Ctrl+G to open the immediate window >> Debug >>
Compile.
Fix any errors which pop up.

Or you may have a reference to an MDB which aren't allowed from an
MDE. You must make an MDE out of the referenced MDB and reference it.

Finally it is possible you have some corrupted VBA. In which case
make a backup first and then try the decompile command as documented
on my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
H

Harry J

Thanks Tony.
It is little faster now. but slower than Access 97.
Harry
-----Original Message-----
Harry J said:
When I try to save design changes that I made to a form,
a report, or a standard module. It takes longer to save
the object than it did in Microsoft Access 95 or 97.
Also the a form takes a long time to open in the current
version (Access 2002) which use to open quickly in the
old version (Access 97)
The database I am talking about is converted from Access
97 to Access 2002.
Click to expand...

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
when am getting error when I try to
make MDE file. What is the solution?
Click to expand...

If A97 then Ctrl+G to open the debug window >> Debug >> Compile and
Save All Modules.
If A2000 or newer then Ctrl+G to open the immediate window >> Debug >>
Compile.
Fix any errors which pop up.

Or you may have a reference to an MDB which aren't allowed from an
MDE. You must make an MDE out of the referenced MDB and reference it.

Finally it is possible you have some corrupted VBA. In which case
make a backup first and then try the decompile command as documented
on my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
.
Click to expand...
 
R

Rick Brandt

Harry J said:
Thanks Tony.
It is little faster now. but slower than Access 97.
Harry
Click to expand...

Don't you know that whenever you upgrade a MS product you are supposed to do so
concurrent with a total hardware upgrade? :)

Seriously, there is (almost) no such thing as a software upgrade that performs
better on the same hardware. Office (particularly Access) versions are some of
the more pronounced examples of this.
 
Top