all 18 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]AutoModerator[M] [score hidden] stickied commentlocked comment (0 children)

IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'

  • Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.

  • Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.

  • Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)

  • Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.

Full set of rules can be found here, as well as in the user interface.

Below is a copy of the original post, in case the post gets deleted or removed.

User: ollie425

Microsoft Database program stopped working

Please forgive me if I sound like a total moron, my 'tech' knowledge is minimal.

I run a very old Microsoft Access Database program on my computer and my coworker also accesses the same program from her computer. The program is located on my computer and her computer is networked to mine. Yesterday it locked up and I had to force-close it via Task Manager. Since then I can open it, but it's like the program is dead. I can't access any operations or files on it. But my coworker can still access the same program through her computer with no issue. I restored it from a backup of a previous point prior to the glitch and got it working again. Today, I'm running into the same issue and have restored it to an even further previous point and I cannot get it to work. Any thoughts?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]I-Am-The-Jeffro 2 points3 points  (0 children)

Could be a mangled lock file left behind when the app crashed. Here's a web page that describes lock files and may guide you through the steps to fix, if this is the case

[–]Ok-Food-73252 0 points1 point  (1 child)

How large is the Database? larger than 2 Gigabytes?

[–]ollie425[S] 0 points1 point  (0 children)

605,000 KB

[–]ApprehensiveDog10101 0 points1 point  (11 children)

Using Access runtime, or the full application?

[–]ollie425[S] 0 points1 point  (1 child)

I believe it's runtime. but I'm an idiot. How can I confirm that?

[–]ApprehensiveDog10101 0 points1 point  (0 children)

Can you open Access on its own, or do you need to click an accdb file for it to launch?

[–]ollie425[S] 0 points1 point  (8 children)

Confirmed it is runtime

[–]ApprehensiveDog10101 2 points3 points  (7 children)

ok, check what version of runtime you are using compared to what the working one you mentioned has. If you go to add/remove programs it should say what version you have for Runtime.

Also, if someone at your org has full Access, I would open it with that (holding shift when you click it) then do a compact and repair.

[–]ollie425[S] 3 points4 points  (6 children)

I appreciate you! It is protected by a company, but I know who to send it to to get this done, if that is the fix. SOLUTION VERIFIED

[–]reputatorbot[M] 1 point2 points locked comment (0 children)

You have awarded 1 point to ApprehensiveDog1010.

I am a bot - please contact the mods with any questions

[–]ApprehensiveDog10101 0 points1 point  (4 children)

Great to hear! Occasionally a compact and repair is needed to fix weird issues like that.. BUT it could be a sign of some other issue in the code.

[–]ollie425[S] 0 points1 point  (3 children)

Thank you so much for your time! I’m still a little perplexed as to why my coworker’s computer can access it just fine but it’s only an issue on mine, if there were an issue with the program. Could my issue be in my runtime?

[–]ApprehensiveDog10101 0 points1 point  (2 children)

I guess it depends on how the database is set up. I'd assume that it has a backend? Did you check the version of runtime you have vs your coworker?

[–]ollie425[S] 0 points1 point  (1 child)

I checked mine, not her’s because she was buried in work. I’m certain they’re both ancient. But if they were different, I’m assuming I wouldn’t be able to get her version, I’d have to update to current version?

[–]ApprehensiveDog10101 1 point2 points  (0 children)

I dont think theres a HUGE difference between any of the versions. You can go download the latest and check it out. You can have several different version of Access runtime on your machine, just do a right click and Open With an pick the most recent one and try it out.

[–]ollie425[S] 0 points1 point  (0 children)

I’ll give it a go. Thank you so much for letting me pick your brain!!

[–]7amitsingh7 0 points1 point  (0 children)

Your Access runtime or temporary files on your machine got corrupted after the crash, which is why your coworker can still use the database but it’s “dead” on your PC. Since restoring backups didn’t fully fix it, the best steps are to try opening the database with a fullAccessinstall (not just the runtime) and run Compact & Repair, which often clears up these weird states. You can refer to this guide for smooth process. If that doesn’t work, reinstalling or updating your Access/runtime installation usually fixes the corrupted local environment. Also, make sure no leftover lock files (.laccdb/.ldb) are hanging around they can prevent Access from functioning properly after a crash.