Cross-Access-platform databases 're-compiles' or refreshes references for a long time

[Lystig]

Hi All,

I'm developing accounting software on Access. It will run on Access 2000,
XP, 2003 and 2007 but only after spending a long time doing something
'fishy', if moved from one version of Access to another.

The program is developed on Access 2003. After distribution it may be loaded
into Access 2002 or 2007 for execution. Here Access will hang for about 20
minutes using full processor capacity. But eventually it finishes and the
application works with no problems at all. Unfortunately very few people
have the patience for the initial 20 minutes and kills Access before it
finishes.

First I thought it was some recompiling - but a full compile in vba takes
only 5-10 seconds. Maybe it is checking up the references all over the
application and recompiles.

Some statistics:
The adp-file reference 7 libraries
contains 480 forms, 215 reports and 30 code modules.
Uncompiled it uses 14 MB - compiled and compacted 23 MB

Searching MSDN for articles gives no results - it is often hard to find
articles which addresses cross-product problems.

Any ideas for further diagnostics - or even an article which references this
problem??

Thanks in advance.

Best regards
Stig Andersen

 

[Alex Dybenko]

Hi,
best approach for you - is to develop using Access 2000, then it will work
on any later version. if this is not possible - then every time you have to
decompile it on Access 2000 and then compile again on 2000. Also make sure
that you are using the ADO version installed on all PCs (I think Access 2000
used ADO 2.1)

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Peter Yang [MSFT]]

Hello Stig,

It's hard to determine the real issue directly here that it takes 20
minutes to start the database in 2002/2007. To find out the root cause of
this issue we may need to analyze memory dumps, this work has to be done by
contacting Microsoft Product Support Services. Therefore, we probably will
not be able to resolve the issue through the newsgroups. I recommend that
you open a Support incident with Microsoft Product Support Services so that
a dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

You may want to add some startup code to print some time information for
tracing this error.

Also, you may want to use filemon/regmon to monitoring the actions of the
application when it "hangs". It sounds like related to sql
connection/network naming etc.

http://www.sysinternals.com/Utilities/Filemon.html
http://www.sysinternals.com/Utilities/regmon.html

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.