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 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.
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
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. 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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. ...
|
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"
...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
| |