UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Accde Crashes, Access 2013    
 
   
ljpitre
post Aug 16 2019, 08:52 AM
Post#1



Posts: 5
Joined: 16-August 19



Using MS Access 2013, I've developed an application that's been running fine for over a year. Once development is completed on changes, I use debug compile to make sure no issues are found. THen I create an ACCDE and push the new release into out testing environment.

Something changed about a week ago. The ACCDB copy run fine. However, now each and every time I create a new ACCDE and try to launch the ACCDE it crashes every time.
I have spent numerous hours researching and have no idea what is causing this. I've attached a screen capture of the MS Access crash window.

I also attached a zipped copy of the error exported from the system event viewer.

Any help will be greatly appreciated. I'm at a complete stand still until I figure this out.
Attached File(s)
Attached File  MS_Access_2013_error_20190816_0734.zip ( 4.51K )Number of downloads: 2
Attached File  Capture.JPG ( 19.62K )Number of downloads: 0
 
Go to the top of the page
 
GroverParkGeorge
post Aug 16 2019, 09:07 AM
Post#2


UA Admin
Posts: 35,695
Joined: 20-June 02
From: Newcastle, WA


Does your VBA still compile in the accdb?

That is the most common problem in cases like this.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
ljpitre
post Aug 16 2019, 11:14 AM
Post#3



Posts: 5
Joined: 16-August 19



Yes VBA compiles cleanly. I'm confident its not coding errors. New ACCDE files from those affected ACCDB files still crash. The only affected ACCDB files are the 21 backup copies I made between 8/7 and yesterday for that specific application. No other MS Access applications were affected.

My theory, my master development copy of the ACCDB was corrupted on 8/8. The corruption dose not seem to affect running the ACCDB. Only creating of ACCDE. All successive backups I made from that day of that specific ACCDB are affected.

I too the previous backup created n 8/7 and it seems fine. However, I have to rebuild all changes made since then. I even tried importing changes, manually copy/paste change from several of the affected backups. all attempts result in crashing ACCDE.
Go to the top of the page
 
GroverParkGeorge
post Aug 16 2019, 11:20 AM
Post#4


UA Admin
Posts: 35,695
Joined: 20-June 02
From: Newcastle, WA


Did you create a clean, new, empty accdb and import the objects from the old accdb? Sometimes that does the trick.

Also, you could try Decompiling.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
theDBguy
post Aug 16 2019, 11:30 AM
Post#5


Access Wiki and Forums Moderator
Posts: 76,321
Joined: 19-June 07
From: SunnySandyEggo


Hi. Welcome to UA! welcome2UA.gif

Is the ACCDE crashing on all computers or just yours? Just curious...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
isladogs
post Aug 16 2019, 12:09 PM
Post#6


UtterAccess VIP
Posts: 1,609
Joined: 4-June 18
From: Somerset, UK


Crossposted with similar responses at https://www.accessforums.net/showthread.php?t=77990

--------------------
Go to the top of the page
 
GroverParkGeorge
post Aug 16 2019, 12:34 PM
Post#7


UA Admin
Posts: 35,695
Joined: 20-June 02
From: Newcastle, WA


If you get an answer that solves your problem, please cross-post that as well. Thanks.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
ljpitre
post Aug 16 2019, 01:50 PM
Post#8



Posts: 5
Joined: 16-August 19



Crashing only on mine? Good point. No one else is here. I will research Monday.

Thanks
Go to the top of the page
 
ljpitre
post Aug 16 2019, 01:51 PM
Post#9



Posts: 5
Joined: 16-August 19



"Option Explicit" yes. "debug compile" yes regular basis. "Decompile" yes regular basis. none resolves this specific issue.

thanks
Go to the top of the page
 
theDBguy
post Aug 16 2019, 01:59 PM
Post#10


Access Wiki and Forums Moderator
Posts: 76,321
Joined: 19-June 07
From: SunnySandyEggo


QUOTE
Crashing only on mine? Good point. No one else is here. I will research Monday.
Good luck! Have a nice weekend!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
ljpitre
post Aug 19 2019, 02:55 PM
Post#11



Posts: 5
Joined: 16-August 19



Using a ACCDB backup about a week old, spent couple days rebuilding it to where I left off last week. At 7am this morning, I packed, decompiled, packed, generated ACCDE. RUns fine. made backup of ACCDB.

After additional screen/module updates, At 8am repeated process. Everything ok.

After additional screen/module updates, At 10am repeated process. Everything ok.

After additional screen/module updates, At 11am repeated process. ACCDE crashes.

Pulled back my 10am backup ACCDB. ACCDE crashes.

Pulled back my 8am backup ACCDB. ACCDE crashes.


Pulled back my 7am backup ACCDB. ACCDE runs fine.

This is driving me crazy. What can this possibility be???
Go to the top of the page
 
isladogs
post Aug 19 2019, 03:44 PM
Post#12


UtterAccess VIP
Posts: 1,609
Joined: 4-June 18
From: Somerset, UK


Determine exactly what you did between 10am and 11am when it crashed.
Next time it crashes, do the same.
Look for common features in the actions taken.

--------------------
Go to the top of the page
 
GroverParkGeorge
post Aug 19 2019, 04:39 PM
Post#13


UA Admin
Posts: 35,695
Joined: 20-June 02
From: Newcastle, WA


One of the reasons it is hard to trouble-shoot problems like this is the seeming randomness of the occurrence. However, as Colin points out, "SOMETHING" is happening and the objective is to figure out what that might be. For example, adding a new VBA Sub or Functions precedes the crash. Was that the direct cause? Or, perhaps the Compact & Repair was done over the network. Or the accde was created in a shared folder out on the network. Maybe there was a network problem...

Did you try creating a new, empty accdb first? And then importing objects from the broken accdb? Sometimes that can help remove the bad actor.


--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd September 2019 - 04:07 AM