473,326 Members | 2,126 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.

Access Database "Stopped Working"

while finishing up my database, suddenly the dreaded "Microsoft Access has stopped working" with the scolling bar below in the box appeared and access restarted. This keeps happening whenever I reopen (either original or backup) I noticed the files were renamed (C:Database21[Conflict] and C:Database21[Conflict]_Backup). Prior to the event everything was working fine and tested. It all started when I clicked a previously working drop down box with a DLookup attached to fill another textbox. Any Ideas? Compacted and repaired with no luck
Jan 18 '13 #1

✓ answered by zmbd

I know... something silly...
1st try to open the DB file while holding the shift key down. So long as you haven't disabled this key yet you might be able to get into the DB still. I've had this happen and work.
I then moved everything out of that DB file into a new one!

2nd: 5.How to Decompile an Access Application Or How to do a Full Fresh Compile

3rd: (because you didn't state the version) How to troubleshoot and to repair a damaged Access 2002 or later database which inculdes NeoPa's solution as well.

There are some shareware and payware tools out there that promise the moon (and proof of string theory); however, I'm a little leary of them as a whole in that the ads tend to be better than the results. However, many of them will get stuff when nothing else works... cost to data ratio needs to be considered.

3 2216
NeoPa
32,556 Expert Mod 16PB
I'm assuming that when you refer to a backup you aren't saying you've kept a proper set? If your only backup is the file listed then you have indeed got yourself into a very dangerous position - and then got unlucky.

I don't have any links to hand for handling a corrupted database (for that's surely your problem), but creating a new one from scratch and importing as many of the objects into it from the corrupted version that you can, and are not themselves corrupted, is the basic idea generally. It can be laborious, and is likely to leave you at least one object that won't import across, but it's better than starting the whole project again from scratch.

I strongly suggest you proceed from here with a good and reliable backup plan to ensure you aren't exposed to such a grave and avoidable situation in future.
Jan 18 '13 #2
zmbd
5,501 Expert Mod 4TB
I know... something silly...
1st try to open the DB file while holding the shift key down. So long as you haven't disabled this key yet you might be able to get into the DB still. I've had this happen and work.
I then moved everything out of that DB file into a new one!

2nd: 5.How to Decompile an Access Application Or How to do a Full Fresh Compile

3rd: (because you didn't state the version) How to troubleshoot and to repair a damaged Access 2002 or later database which inculdes NeoPa's solution as well.

There are some shareware and payware tools out there that promise the moon (and proof of string theory); however, I'm a little leary of them as a whole in that the ads tend to be better than the results. However, many of them will get stuff when nothing else works... cost to data ratio needs to be considered.
Jan 21 '13 #3
zmbd
5,501 Expert Mod 4TB
Would you mind posting the steps you took that solved your problem, please?
Feb 23 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Bill | last post by:
I used to be able to run the following ASP code on our corp machine (W2K Server Edition and IIS-5) and successfully send a net-msg to anyone on our intranet. Last week it stopped working... and...
0
by: gbaitsur | last post by:
Hi! I really hope that someone could help me. I have a vb.net application that uses the unmanaged dll, which is part of an independent software. The code is: Declare Sub SUB_NAME Lib...
4
by: MoF | last post by:
Hello! I have for a long time used the line: Set FS=Server.CreateObject("Scripting.FileSystemObject") in my ASP code. Suddenly one day this week it stopped working and I now get the error: ...
2
by: samadams_2006 | last post by:
I'm trying to get a simple VB.NET "Web Application" (not a regular application) to work with an Access Database. Seems simple enough, but I cannot seem to get it working. If anyone has a simple...
5
by: djsdaddy | last post by:
Good Day All, I have some EEO data in an old dBase4 database that I have converted to an Access table. Since dBase was not a relational database, I didn't create any key fields. I linked all of the...
1
by: Parsed Cheese | last post by:
After two days I am at wits end, but I am too OCD'ed to give up. Please tell me what I have got wrong because no Validation Error is being thrown. The element: "<datestamp>I should...
0
by: Chuck.Dieterle | last post by:
I have a very frustrating problem. I have a situation that works fine on some computers, but not on others. I have SQL Server Express 2005 and Access 2003 loaded on 4 computers. I have set up a...
2
by: rola248 | last post by:
hi, after compiling my program and having no errors or warnings,and when running it i get this message:"main.exe has stopped working".... i can't fix this problem,,,can anyone help plz????
3
by: Haiyan | last post by:
Dear Experts: I made one GUI interface with Tkinter. I have some buttons on the GUI and one button is designed as "start test" which will invoke one "start test" window. I put one "ok" and one...
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: 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
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...
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.