473,322 Members | 1,755 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,322 software developers and data experts.

access error logging/troubleshooting ideas

Every few weeks the db I'm working on fails to open. The opening
splash screen hangs and after a while I get a message from Windows
that Access closed abnormally and information was written to an error
log. Nothing shows up in the event viewer. Is there someplace I can
find the error info?

Normally when the db opens, a splash screen comes up while a bunch of
code runs behind it. This code checks that the attached tables are
found, writes some values to a local table based on dlookups, and
opens some forms. Nothing fancy. And, when I bypass the startup code,
open the db and step through it, everything works fine.

Does anyone have any suggestions about how to troubleshoot this? It's
getting *really* old.

Thanks,
Sharon
Nov 13 '05 #1
4 2005
shunah wrote:
Every few weeks the db I'm working on fails to open. The opening
splash screen hangs and after a while I get a message from Windows
that Access closed abnormally and information was written to an error
log. Nothing shows up in the event viewer. Is there someplace I can
find the error info?

Normally when the db opens, a splash screen comes up while a bunch of
code runs behind it. This code checks that the attached tables are
found, writes some values to a local table based on dlookups, and
opens some forms. Nothing fancy. And, when I bypass the startup code,
open the db and step through it, everything works fine.

Does anyone have any suggestions about how to troubleshoot this? It's
getting *really* old.

Thanks,
Sharon


You might want to insert some code to add a record (insert query) to a
table or write a line to a text file (see Open, Put, Write, etc in help)
that tracks your progress. For example, you open a form. Write to the
table "Opened main form". You then run some computations. Then write
"Computations performed."

When the program breaks, you now have the last option performed and you
know where your program is blowing up.
Nov 13 '05 #2
A little too fast on the post button. I forgot to say this is
happening on A2K with Jet 8.0 on W2K, split FE/BE. Also, when this
happens the VBE doesn't work as it should -- I can view code that's
already open but can't open the immediate window or the project
explorer. I can compact and repair from within Access, but can't
successfully run the MS JetComp utility on the db. The only way I can
"fix" it is by creating a new db and importing everything into it.

This time the root problem seemed to have been a corrupted index
and/or table.

But this has happened several times, and I'd be interested if anyone
has seen something like this.

Thanks,
S

sh****************@elemenopy.org (shunah) wrote in message news:<91*************************@posting.google.c om>...
Every few weeks the db I'm working on fails to open. The opening
splash screen hangs and after a while I get a message from Windows
that Access closed abnormally and information was written to an error
log. Nothing shows up in the event viewer. Is there someplace I can
find the error info?

Normally when the db opens, a splash screen comes up while a bunch of
code runs behind it. This code checks that the attached tables are
found, writes some values to a local table based on dlookups, and
opens some forms. Nothing fancy. And, when I bypass the startup code,
open the db and step through it, everything works fine.

Does anyone have any suggestions about how to troubleshoot this? It's
getting *really* old.

Thanks,
Sharon

Nov 13 '05 #3
shunah wrote:
A little too fast on the post button. I forgot to say this is
happening on A2K with Jet 8.0 on W2K, split FE/BE. Also, when this
happens the VBE doesn't work as it should -- I can view code that's
already open but can't open the immediate window or the project
explorer. I can compact and repair from within Access, but can't
successfully run the MS JetComp utility on the db. The only way I can
"fix" it is by creating a new db and importing everything into it.

This time the root problem seemed to have been a corrupted index
and/or table.

But this has happened several times, and I'd be interested if anyone
has seen something like this.

Thanks,
S

sh****************@elemenopy.org (shunah) wrote in message news:<91*************************@posting.google.c om>...
Every few weeks the db I'm working on fails to open. The opening
splash screen hangs and after a while I get a message from Windows
that Access closed abnormally and information was written to an error
log. Nothing shows up in the event viewer. Is there someplace I can
find the error info?

Normally when the db opens, a splash screen comes up while a bunch of
code runs behind it. This code checks that the attached tables are
found, writes some values to a local table based on dlookups, and
opens some forms. Nothing fancy. And, when I bypass the startup code,
open the db and step through it, everything works fine.

Does anyone have any suggestions about how to troubleshoot this? It's
getting *really* old.

Thanks,
Sharon


You might have a crappy network card.
Nov 13 '05 #4
sh****************@elemenopy.org (shunah) wrote in message news:<91*************************@posting.google.c om>...
Every few weeks the db I'm working on fails to open. The opening
splash screen hangs and after a while I get a message from Windows
that Access closed abnormally and information was written to an error
log. Nothing shows up in the event viewer. Is there someplace I can
find the error info?

Normally when the db opens, a splash screen comes up while a bunch of
code runs behind it. This code checks that the attached tables are
found, writes some values to a local table based on dlookups, and
opens some forms. Nothing fancy. And, when I bypass the startup code,
open the db and step through it, everything works fine.

Does anyone have any suggestions about how to troubleshoot this? It's
getting *really* old.

Thanks,
Sharon


If your code is running asynchronously, and you need it synchronous,
try adding a few DoEvents in between your calls, which will force the
first call to finish before the next can start.
Nov 13 '05 #5

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

Similar topics

0
by: Peter Mather | last post by:
Hi, I have a database that has been running under Access 97. Actually it was developed in teh early days of Access and has been successfully converted each time. This time when I start it under...
7
by: Ottar | last post by:
I've made a program sorting incomming mail in public folder. The function runs every minute by using the form.timer event. In Access XP it runs for weeks, no problem. Access 2003 runs the same...
1
by: JohnC | last post by:
I have this exact same scenario. It is new and seems to be related to when we installed Adobe 7.0 Standard/Professional. We have an MDB on a LAN file server. Using Access 2K and Windows 2K. ...
29
by: Patrick | last post by:
I have the following code, which regardless which works fine and logs to the EventViewer regardless of whether <processModel/> section of machine.config is set to username="SYSTEM" or "machine" ...
10
by: Shawn | last post by:
JIT Debugging failed with the following error: Access is denied. JIT Debugging was initiated by the following account 'PLISKEN\ASPNET' I get this messag in a dialog window when I try to open an...
3
by: MattB | last post by:
Yes, it's this one again. I have a web application that works in most environments, but we've installed at a client site who wanted to use a Win2k3 domain controller (yes I know this is a bad...
0
by: Shane | last post by:
Does anyone have any advise on how I can fix the error message shown below? Thanks in advance for any ideas, Shane Server Error in '/' Application....
3
by: nicholas.petrella | last post by:
I am currently trying to use the python logging system as a core enterprise level logging solution for our development and production environments. The rotating file handler seems to be what I...
0
by: Andy | last post by:
Thanks Peter, I thought I'd give an update on this problem. My application had 2 assemblies that contained classed for the Data access and business logic layer. It was on one of them that I was...
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: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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...
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: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.