473,503 Members | 1,635 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Open a corrupt Access 97 db

Hi there

Does anyone now how to open a corrupted database without running
compact/repair?

The latest version of jet is installed.
Nov 13 '05 #1
2 1242
On Mon, 14 Feb 2005 17:34:39 GMT, "Ian Pressman"
<ia**********@my-deja.com> wrote:

Open it in Notepad :-)

No, seriously, your best bet may be to put a backup back.
Next best is a serious data recovery service. Pksolutions - if they
still take this business - is the best there is.
You can also try to import objects into a new MDB - your mileage may
vary depending on how serious the corruption is. You may find more
info here:
http://members.iinet.net.au/~allenbrowne/ser-47.html He also has an
article about preventing corruption in the first place.

-Tom.
Hi there

Does anyone now how to open a corrupted database without running
compact/repair?

The latest version of jet is installed.


Nov 13 '05 #2
"Ian Pressman" <ia**********@my-deja.com> wrote:
Does anyone now how to open a corrupted database without running
compact/repair?
The latest version of jet is installed.


Make a copy.

Try the Jetcomp utility.

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #3

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

Similar topics

2
2287
by: Filips Benoit | last post by:
A particular form - always the same - sometimes becomes corrupt after saving. Error msg = The expression On Open you entered as the event property settings produced the following error: A...
21
2669
by: Dan | last post by:
Hi, just ran into my first instance of a backend Access97 database not compacting. I'm getting the "MSACCESS.EXE has generated errors.." message on compact. I've narrowed it down to the largest...
6
2422
by: Annette Massie | last post by:
I have an 2000 database that is getting corrupt many times a day. The application is sittin on a network with about 5 users accessing it. Most times I get a call with the user saying the...
5
2720
by: elieli_132 | last post by:
Hi, My problem is the following: Made changes to code in form and closed the form. Now unable to open / design the form. - Tried copying and pasting - the new one does not open /display....
7
2733
by: TDIOwa | last post by:
I have a form that has a specific date on it. I want to open another form that has the Active Control Calendar on it. I want to open this form to the specific date on the first form. I have...
2
1530
by: Jefferson Humber | last post by:
Is there a supported/official way to backup open Access Databases ? We have an Access97 DB that is open 24/7, that ideally needs to backed up every night without disconnecting every user/process....
4
12260
by: bbdobuddy | last post by:
Hi, How do I open a Microsoft Access 2003 form from Visual Basic.net Thanks in advance bbdobuddy
17
4867
by: shineofleo | last post by:
Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was...
2
1850
by: tubby | last post by:
Does a py script written to open and read binary files on Windows affect files on a Linux or Mac machine in a negative way? My concern is portability and safety. I want scripts written within...
1
2232
by: shayvillere | last post by:
I have a corrupt record that disappears after a compact, but reappears several days later. This is on a widely distributed Access 2003 application that is used by about 100 users. The database...
0
7202
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7086
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7332
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6991
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5578
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5014
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
4673
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3154
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.