473,326 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Microsoft access has encountered a problem .......

I have been getting the above error message intermittently when I open any
one of five or six forms in design view, change some control formatting
(like backcolor) and try to open the form in form view.
The application is closed down, and when I reopen it, all changes have been
saved, and all appears well.
It makes no difference if I select the option to repair & backup etc or not.
I usually opt to send the error report (if only out of spite).
Is anyone else having similar problems?

--
Bob Darlington
Brisbane
Nov 13 '05 #1
10 1703
Bob Darlington wrote:
I have been getting the above error message intermittently when I open any
one of five or six forms in design view, change some control formatting
(like backcolor) and try to open the form in form view.
The application is closed down, and when I reopen it, all changes have been
saved, and all appears well.
It makes no difference if I select the option to repair & backup etc or not.
I usually opt to send the error report (if only out of spite).
Is anyone else having similar problems?


What version? Which Service Pack? Does the error reporting bring up a
"More info" link?

--
Pretentious? Moi?
Nov 13 '05 #2
Access 2002 with SP3 on WinXP SP2.
Yes, there is a more info button, which brings up pages of stuff which may
as well be in Greek.
Next time it comes up (and it is intermittent) I will copy and post it if
you like?

--
Bob Darlington
Brisbane
"Trevor Best" <nospam@localhost> wrote in message
news:41***********************@auth.uk.news.easyne t.net...
Bob Darlington wrote:
I have been getting the above error message intermittently when I open
any one of five or six forms in design view, change some control
formatting (like backcolor) and try to open the form in form view.
The application is closed down, and when I reopen it, all changes have
been saved, and all appears well.
It makes no difference if I select the option to repair & backup etc or
not.
I usually opt to send the error report (if only out of spite).
Is anyone else having similar problems?


What version? Which Service Pack? Does the error reporting bring up a
"More info" link?

--
Pretentious? Moi?

Nov 13 '05 #3
RE/
Is anyone else having similar problems?


My guess is that "Microsoft Access is having a problem..." is too generic for
anybody to say they have or haven't had the same root cause.

Having had it a number of times over the years, my first reaction is that
something is corrupted in the DB.

The first thing I've always done is to rebuild the app by importing all objects
into a new empty DB. Sometimes it's worked, sometimes it has not.

Next step would be to do a series of (undocumented) SaveAsText commands from an
Immediate window and use LoadFromText to pull those modules into a new empty DB.
My guess is that above a certain application size/complexity you could write a
few loops to do this faster than you could do it by hand.
--
PeteCresswell
Nov 13 '05 #4
"(Pete Cresswell)" <x@y.z> wrote:
Next step would be to do a series of (undocumented) SaveAsText commands from an
Immediate window and use LoadFromText to pull those modules into a new empty DB.
My guess is that above a certain application size/complexity you could write a
few loops to do this faster than you could do it by hand.


Sample code at http://www.datastrat.com/Code/DocDatabase.txt

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
Nov 13 '05 #5
Bob Darlington wrote:
Access 2002 with SP3 on WinXP SP2.
Yes, there is a more info button, which brings up pages of stuff which may
as well be in Greek.
Next time it comes up (and it is intermittent) I will copy and post it if
you like?


The fact you have a more info button would suggest that there is an
update available for Access, visit http://officeupdate.microsoft.com and
check for updates, like WindowsUpdate you'll need IE to do it.

I would follow Pete's suggestion of importing everything into a new db,
see if that helps first.

In the meantime, keep sending those error reports to MS, they do take
notice of them. I had regular problems like this with Access 2002 SP2,
my error reports caused me to get into dialog with one of the developers
and SP3 fixed my problem.

--
Pretentious? Moi?
Nov 13 '05 #6
Trevor Best <nospam@localhost> wrote:
In the meantime, keep sending those error reports to MS, they do take
notice of them. I had regular problems like this with Access 2002 SP2,
my error reports caused me to get into dialog with one of the developers
and SP3 fixed my problem.


MS very much pays attention to those error reports. They love them. Their number
one goal on SPs is to fix those errors where the software crashes. MS personnel
knows how much pain is caused when you lose files and work you've already done.

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
Nov 13 '05 #7
Thanks Trevor,
The most recent update (apart from 2 security patches) is SP3, which I
already have installed.

The error dialog is pretty standard, and has a hyperlink:
'To see what data this error report contains Click here'
The is no 'More info' button.
The error report cannot be copied, and runs to what looks like hundreds of
pages.

I'll take your advice and keep sending the error reports.

I have only recently imported all objects into a new db to solve a different
problem.

--
Bob Darlington
Brisbane
"Trevor Best" <nospam@localhost> wrote in message
news:41***********************@auth.uk.news.easyne t.net...
Bob Darlington wrote:
Access 2002 with SP3 on WinXP SP2.
Yes, there is a more info button, which brings up pages of stuff which
may as well be in Greek.
Next time it comes up (and it is intermittent) I will copy and post it if
you like?


The fact you have a more info button would suggest that there is an update
available for Access, visit http://officeupdate.microsoft.com and check
for updates, like WindowsUpdate you'll need IE to do it.

I would follow Pete's suggestion of importing everything into a new db,
see if that helps first.

In the meantime, keep sending those error reports to MS, they do take
notice of them. I had regular problems like this with Access 2002 SP2, my
error reports caused me to get into dialog with one of the developers and
SP3 fixed my problem.

--
Pretentious? Moi?

Nov 13 '05 #8
Thanks Tony and Pete.
I'll give that a go.

--
Bob Darlington
Brisbane
"(Pete Cresswell)" <x@y.z> wrote in message
news:c4********************************@4ax.com...
RE/
Is anyone else having similar problems?


My guess is that "Microsoft Access is having a problem..." is too generic
for
anybody to say they have or haven't had the same root cause.

Having had it a number of times over the years, my first reaction is that
something is corrupted in the DB.

The first thing I've always done is to rebuild the app by importing all
objects
into a new empty DB. Sometimes it's worked, sometimes it has not.

Next step would be to do a series of (undocumented) SaveAsText commands
from an
Immediate window and use LoadFromText to pull those modules into a new
empty DB.
My guess is that above a certain application size/complexity you could
write a
few loops to do this faster than you could do it by hand.
--
PeteCresswell

Nov 13 '05 #9
Progress report.
Used SaveasText etc, and so far so good. Haven't had the message recur.
Thanks again for the help.

--
Bob Darlington
Brisbane
"(Pete Cresswell)" <x@y.z> wrote in message
news:c4********************************@4ax.com...
RE/
Is anyone else having similar problems?


My guess is that "Microsoft Access is having a problem..." is too generic
for
anybody to say they have or haven't had the same root cause.

Having had it a number of times over the years, my first reaction is that
something is corrupted in the DB.

The first thing I've always done is to rebuild the app by importing all
objects
into a new empty DB. Sometimes it's worked, sometimes it has not.

Next step would be to do a series of (undocumented) SaveAsText commands
from an
Immediate window and use LoadFromText to pull those modules into a new
empty DB.
My guess is that above a certain application size/complexity you could
write a
few loops to do this faster than you could do it by hand.
--
PeteCresswell

Nov 13 '05 #10
Spoke too soon.
Its happening again this morning whenever I try to save a report which is
open in design view with a different name.

--
Bob Darlington
Brisbane
"(Pete Cresswell)" <x@y.z> wrote in message
news:c4********************************@4ax.com...
RE/
Is anyone else having similar problems?


My guess is that "Microsoft Access is having a problem..." is too generic
for
anybody to say they have or haven't had the same root cause.

Having had it a number of times over the years, my first reaction is that
something is corrupted in the DB.

The first thing I've always done is to rebuild the app by importing all
objects
into a new empty DB. Sometimes it's worked, sometimes it has not.

Next step would be to do a series of (undocumented) SaveAsText commands
from an
Immediate window and use LoadFromText to pull those modules into a new
empty DB.
My guess is that above a certain application size/complexity you could
write a
few loops to do this faster than you could do it by hand.
--
PeteCresswell

Nov 13 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ray | last post by:
Date problem. Using non American date formats with Microsoft Access and Visual Basic. I set my regional settings to English(Ireland) or English(United Kingdom) and my date appears in Access as...
0
by: Ryan Strauss | last post by:
I was wondering if someone could help me out with this exception I'm encountering on a few of our C# reports. The issue occurs sporadically and only to certain users, myself not included. Whenever...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
7
by: Randy Harris | last post by:
I've run into a nasty problem, can't find a way around it. This line of code: DoCmd.OutputTo acOutputTable, "GSQ_Criteria", acFormatXLS, FileName errors with #2385 - Errors were...
1
by: sticks | last post by:
I hope someone can help with this strange problem I've encountered: I have an Access interface that is used to access a SQL database. The interface uses some stored procedures to display...
2
by: bobc | last post by:
Any help appreciated with this problem -- I have a Microsoft Access 2002 application. The Access mdb has a refence to DAO 3.6 (not ADO). A form is bound to a linked table in a second mdb. In the...
1
by: PJ6 | last post by:
Pages were working fine that used Microsoft.ApplicationBlocks.Data.dll, and now, with no changes, we're getting this - Access is denied: 'Microsoft.ApplicationBlocks.Data'. All I can find with...
4
by: Saher | last post by:
Hi, im new on this forum and just joined today. I HAVE A HUGE PROBLEM! My microsoft access does not work. I click on the link, that opens up to microsoft access, its fine untill then. But when i try...
39
by: Martin | last post by:
I have an intranet-only site running in Windows XPPro, IIS 5.1, PHP 5.2.5. I have not used or changed this site for several months - the last time I worked with it, all was well. When I tried it...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.