ACCESS 2003 CRASHES PERMANENT !!!

P

PACALA_BA

Hi (MS ACCESS 2003, file format 2002/03)
i am using LARGE PROGRAM-(NOT-DATA) DATABASE MDB/MDE
MDB = cca. 15-18 MB, MDE = cca. 9MB
3 class modules 217 KB, 16 MODULES 5.05 MB, 3 REPORTS, 8 FORMS
Help,...There are PERMANET CRASHES(100 Reported to MICROSOFT) !!!!
I have tryed different setings
Compile on Demand,Backgroud compile,..but after some Time Crashes !!!
-------------------------------------
There are COMPILE ERRORS !!!!!!!!!!!!!!!
strSQL = "select * from [" & lcTAbleNAme & "] where ...." & lcWhere & "...."
After compile, the string is SHORTEN
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["
-------------------------------------
All the Best PACALA JAN
eMAIL: (e-mail address removed),[email protected]


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-8c71-6f2e776fabe3&dg=microsoft.public.access
 
L

Larry Linson

Do you have a question? Also, I see no obvious "suggestion" to Microsoft,
though the legend at the bottom of the post indicates it is one. If you just
wanted a place to "vent your anger", you've done so; but if you want
assistance, perhaps the following will help:

This newsgroup is for peer-to-peer assistance, and newsgroups work best on
specific answers to precise and concise questions (see the FAQ at
http://www.mvps.org for good suggestions on effective use of newsgroups). It
is not a venue for reporting problems to Microsoft, nor is it regularly
monitored by Microsoft employees. The "Microsoft MVPs" who respond here are
not employed by Microsoft, but have been recognized by Microsoft for their
contributions to the Microsoft user community (see
http://mvp.support.microsoft.com for an explanation).

I am assisting someone at the present time on a database that is
approximately the same size as you describe, and they are not experiencing
the kind of difficulties you describe. I have worked on even larger
databases without this kind of problem.

As no one here has access to your database, and it is very likely that some
detailed analysis and significant effort would be required to resolve
drastic "crashes", I suspect that all we will be able to do is to suggest
areas to investigate, items to check, and possible ways to circumvent the
problems. I do not understand what you mean by "PERMANENT CRASHES".

Let's start with these:

(1) If you are executing a monolithic database, or a split database with
the UI portion on a server, or with more than one user logged in, move all
the pieces to one workstation, and it there. If you are running on a
wireless network, move all the pieces to one workstation, and test it there.
(2) Check to determine that your Access 2003 has, at least, SP 2 installed.
(On the menu Help | About.) If not, visit the Microsoft website, download
and install SP 2.
(3) At this point, before I pursued the matter any further, I would
Decompile, Save all modules as Text, create a new, empty database, copy the
objects (except modules, tables, and relationships) from the database that
is failing, and Load all Modules as Text. Create another new, empty
database, and copy in the tables and relationships -- this will be your back
end. Use File | Get External Data | Link to link the tables.
(4) Then I would Compile... if you find that your statement or statements
are still being truncated, then I would suspect that you have exceeded the
limit of statements that can be in a module (in one or more of the modules)
and you might try subdividing some of the larger modules into smaller ones.
(5) I'd then uninstall Access (or Office if Access was installed as part of
the package), and re-install it, along with all SPs.

Let me repeat: I see no size limitation that has obviously been exceeded,
but there could be some individual object that exceeds a limitation. There's
just not enough information to be able to do more than recommend you visit
MVP Tony Toews' site at http://www.granite.ab.ca/accsmstr.htm which has
excellent coverage of issues with split, multiuser databases. And, then
visit some of the resources listed in the Resource list at
http://sp.ntpcug.org/accesssig/.

You didn't say how you were reporting the problem to Microsoft... if using
the MsgBox to "send a report to Microsoft" -- those are used for determining
areas of concentration for future releases. They are NOT for initiating
help incidents. You would need to use the normal channels for obtaining
paid service (and I agree, it is not inexpensive) from Microsoft. If,
indeed, they determine that your problem is a product defect, not an error
on your part, your payment will be refunded.

Best of luck...

Larry Linson
Microsoft Office Access MVP

PACALA_BA said:
Hi (MS ACCESS 2003, file format 2002/03)
i am using LARGE PROGRAM-(NOT-DATA) DATABASE MDB/MDE
MDB = cca. 15-18 MB, MDE = cca. 9MB
3 class modules 217 KB, 16 MODULES 5.05 MB, 3 REPORTS, 8 FORMS
Help,...There are PERMANET CRASHES(100 Reported to MICROSOFT) !!!!
I have tryed different setings
Compile on Demand,Backgroud compile,..but after some Time Crashes !!!
-------------------------------------
There are COMPILE ERRORS !!!!!!!!!!!!!!!
strSQL = "select * from [" & lcTAbleNAme & "] where ...." & lcWhere &
"...."
After compile, the string is SHORTEN
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["
-------------------------------------
All the Best PACALA JAN
eMAIL: (e-mail address removed),[email protected]


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-8c71-6f2e776fabe3&dg=microsoft.public.access
 
P

PACALA_BA

Hi, Thank you.
But in last month
100 OFFICCE-CRASHES Reported to MICROSOFT.....
from my PC-eMAIL: (e-mail address removed)
***********************************


Larry Linson said:
Do you have a question? Also, I see no obvious "suggestion" to Microsoft,
though the legend at the bottom of the post indicates it is one. If you just
wanted a place to "vent your anger", you've done so; but if you want
assistance, perhaps the following will help:

This newsgroup is for peer-to-peer assistance, and newsgroups work best on
specific answers to precise and concise questions (see the FAQ at
http://www.mvps.org for good suggestions on effective use of newsgroups). It
is not a venue for reporting problems to Microsoft, nor is it regularly
monitored by Microsoft employees. The "Microsoft MVPs" who respond here are
not employed by Microsoft, but have been recognized by Microsoft for their
contributions to the Microsoft user community (see
http://mvp.support.microsoft.com for an explanation).

I am assisting someone at the present time on a database that is
approximately the same size as you describe, and they are not experiencing
the kind of difficulties you describe. I have worked on even larger
databases without this kind of problem.

As no one here has access to your database, and it is very likely that some
detailed analysis and significant effort would be required to resolve
drastic "crashes", I suspect that all we will be able to do is to suggest
areas to investigate, items to check, and possible ways to circumvent the
problems. I do not understand what you mean by "PERMANENT CRASHES".

Let's start with these:

(1) If you are executing a monolithic database, or a split database with
the UI portion on a server, or with more than one user logged in, move all
the pieces to one workstation, and it there. If you are running on a
wireless network, move all the pieces to one workstation, and test it there.
(2) Check to determine that your Access 2003 has, at least, SP 2 installed.
(On the menu Help | About.) If not, visit the Microsoft website, download
and install SP 2.
(3) At this point, before I pursued the matter any further, I would
Decompile, Save all modules as Text, create a new, empty database, copy the
objects (except modules, tables, and relationships) from the database that
is failing, and Load all Modules as Text. Create another new, empty
database, and copy in the tables and relationships -- this will be your back
end. Use File | Get External Data | Link to link the tables.
(4) Then I would Compile... if you find that your statement or statements
are still being truncated, then I would suspect that you have exceeded the
limit of statements that can be in a module (in one or more of the modules)
and you might try subdividing some of the larger modules into smaller ones.
(5) I'd then uninstall Access (or Office if Access was installed as part of
the package), and re-install it, along with all SPs.

Let me repeat: I see no size limitation that has obviously been exceeded,
but there could be some individual object that exceeds a limitation. There's
just not enough information to be able to do more than recommend you visit
MVP Tony Toews' site at http://www.granite.ab.ca/accsmstr.htm which has
excellent coverage of issues with split, multiuser databases. And, then
visit some of the resources listed in the Resource list at
http://sp.ntpcug.org/accesssig/.

You didn't say how you were reporting the problem to Microsoft... if using
the MsgBox to "send a report to Microsoft" -- those are used for determining
areas of concentration for future releases. They are NOT for initiating
help incidents. You would need to use the normal channels for obtaining
paid service (and I agree, it is not inexpensive) from Microsoft. If,
indeed, they determine that your problem is a product defect, not an error
on your part, your payment will be refunded.

Best of luck...

Larry Linson
Microsoft Office Access MVP

PACALA_BA said:
Hi (MS ACCESS 2003, file format 2002/03)
i am using LARGE PROGRAM-(NOT-DATA) DATABASE MDB/MDE
MDB = cca. 15-18 MB, MDE = cca. 9MB
3 class modules 217 KB, 16 MODULES 5.05 MB, 3 REPORTS, 8 FORMS
Help,...There are PERMANET CRASHES(100 Reported to MICROSOFT) !!!!
I have tryed different setings
Compile on Demand,Backgroud compile,..but after some Time Crashes !!!
-------------------------------------
There are COMPILE ERRORS !!!!!!!!!!!!!!!
strSQL = "select * from [" & lcTAbleNAme & "] where ...." & lcWhere &
"...."
After compile, the string is SHORTEN
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["
-------------------------------------
All the Best PACALA JAN
eMAIL: (e-mail address removed),[email protected]


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-8c71-6f2e776fabe3&dg=microsoft.public.access
 
L

Larry Linson

PACALA_BA said:
Hi, Thank you.
But in last month
100 OFFICCE-CRASHES Reported to MICROSOFT.....
from my PC-eMAIL: (e-mail address removed)
***********************************

You quoted the following, but you still didn't say to whom (what e-mail
address) at Microsoft you were addressing your e-mails "OFFICE-CRASHES" nor
did you indicate that you opened a service incident with product support.
If, indeed, there are compiler errors, that is what you _must_ do to
initiate the process of obtaining a correction. You did not indicate what
response you received from Microsoft. The procedures for obtaining service
from Microsoft vary by region, and I do not know what they are in your
region, but the following seems to be a general procedure, worldwide:

I would advise that you start at http://office.microsoft.com, and on the
first/home page, click on "Help and How-To", then on the page that opens
scroll down until you see, in the leftmost column, "Product Support". Click
on "Product Support". A page will open listing the various editions of
Office for which support can be obtained from Microsoft... under the
particular edition/version of Office, choose the version of Access with
which you are having problems. If I choose "Access 2003", that takes me to
the page "Access 2003 Solution Center" which offers many options for
obtaining information and support (most of them free), but if you have
researched those and you have found no help, in the upper right hand corner,
there is a link "Need More Help?" which will lead you through the process of
how to "Contact a Support Professional by Email, Online, or Phone". If you
do so, and what you are reporting is determined to be a product defect, the
charge for the support call will be refunded. If it is determined not to be
a product defect, but due to user actions, then there will be a charge for
the support incident.

Albert Einstein is quoted as saying, "The definition of insanity is
repeating the same action over and over and expecting a different result."
If you got no response from an appropriate organization at Microsoft, a
hundred tries should be enough to convince you that you should change your
approach.
You didn't say how you were reporting the problem to Microsoft... if using
the MsgBox to "send a report to Microsoft" -- those are used for determining
areas of concentration for future releases. They are NOT for initiating
help incidents. You would need to use the normal channels for obtaining
paid service (and I agree, it is not inexpensive) from Microsoft. If,
indeed, they determine that your problem is a product defect, not an error
on your part, your payment will be refunded.

I believe I also explained that the information you provided is insufficient
for anyone to even _guess_ what your problem is, much less to diagnose it,
and even less to assist you in solving it. Allen gave you some suggestions.

If you believe you have exhausted all the possibilities of correcting this
using free support, and are unalterably opposed to taking a chance on paid
support (my guess would be that, for a database application of this size,
you have invested more than enough time and effort to warrant opening a paid
support incident), that it is time to uninstall Access (or all of Office),
reinstall it, make certain you have all the Service Packs for your version,
and try again.

Again, I will repeat -- it is not the size of your database application that
is causing your problem. Your database is not "small" but, it does not come
_near_ straining the limit of total database size (for Access 2000 and
later, a single database can be as large as 2 gigabytes). You might be at
the limit for some object within the database, for example, there is a
maximum number of controls during the lifetime of a form or report -- though
you can work around it if you encounter it. You could, of course, be
experiencing database corruption, and there are steps that can be taken to
try to correct that, as well -- but sometimes all of those steps are not
enough, which would mean you have to go back to a backup copy that works,
and re-start from that working copy.

I am sorry that you are experiencing these difficulties, and I would be
delighted if someone in this newsgroup could help you. But yet another
repetition that you have reported the crashes to Microsoft a hundred times
will not provide anyone enough information to even begin to help. Finally,
helpful as we try to be, all the answers here are from _volunteers_, and our
time and energy are limited -- we are unable to devote the time and energy
to a problem that Microsoft Product Support can devote. Newsgroups are
useful for providing specific answers to specific problems that can be
described, and the description of which is "precise and concise".

Larry Linson
Microsoft Office Access MVP
 
D

David W. Fenton

There are COMPILE ERRORS

Then fix them. If you have compile errors, you have no business
trying to claim bugs in Access (which is what it seems you are
trying to do). It's *your* code that has the problems in it. If it
didn't, then it would compile.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top