473,313 Members | 1,461 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,313 software developers and data experts.

Can not open database file

Hi, all

We have a database which was running on the server and used by several
users. We can not the database now with the following message:

The "*.mdb" need to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while
the Access database was open.

I tried to compact and repair, but it was failed. I tried to open a new
blank database file and import the bad database file, it was failed
too.

Please give me some suggestions!

Thanks a lot for the help!

Nov 13 '05 #1
4 5681
restore it from your last backup. (you do backup daily, don't you?)

Nov 13 '05 #2
ba**********@yahoo.com wrote:
The "*.mdb" need to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while
the Access database was open.


Unless someone comes up with a solution, tt sounds to me like someone
tried to open it in MS Word which destroys mdbs. Hopefully you've a
back up somewhere along the line.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #3
I had this problem with a client's app this week. They didn't realize that
their backup of the back end didn't include the .mdb file (their network
contractor put it on a dedicated workstation because it was a mission
critical file, but then didn't back it up because it was just a workstation.
sigh.

I went after the file by OKing the attempt to fix - and it did. However, it
went from 15 mb to 5 mb in the process. I checked every table by opening
and jumping to the last record - everything looked good. I ran some of the
summary reports and the numbers looked right.

Any ideas on why so much space was recovered. I compacted MY backup of the
db from the prior week and got very little size reduction.

Any ideas?

Tim Mills-Groninger
<ba**********@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Hi, all

We have a database which was running on the server and used by several
users. We can not the database now with the following message:

The "*.mdb" need to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while
the Access database was open.

I tried to compact and repair, but it was failed. I tried to open a new
blank database file and import the bad database file, it was failed
too.

Please give me some suggestions!

Thanks a lot for the help!

Nov 13 '05 #4
In article <11**********************@g43g2000cwa.googlegroups .com>,
ba**********@yahoo.com Fri, 30 Sep 2005 09:53:44 writes
I tried to compact and repair, but it was failed. I tried to open a new
blank database file and import the bad database file, it was failed
too.

To be expected - if you cannot open a database then you cannot import
from it.

If you can open it but cannot compact it then the import method has
value.
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #5

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

Similar topics

1
by: user mysql | last post by:
HELLO FRIENDS. HERE A FANTASTIC NEWS FOR MYSQL WINDOWS USER. READE THIS. The article is grab from www/internetnews/com/ DO YOU THINK THAT IS A GOOD NEWS ? ...
4
by: Andras Gilicz | last post by:
Hi VB fans I'm working on a relatively large project in VB6 with about a dozen forms, including graphs, labels, text boxes, etc. The software itself is actually a flow simulator with more or...
46
by: Steve | last post by:
Access97 Database The database is split into a frontend and backend and not connected to any other database. The database has an unbound report with 15 subreports. Some of the subreports include...
6
by: Kenneth Courville | last post by:
Hello, I'm looking for assistance with the Access object model. I know this is VB, but I'm building an Office Add-using C# directed at Access 2002. I'm literate in VB, so you can reply in VB... I...
10
by: vvenk | last post by:
Hello: When I tried to use an Access database, I get the following exception: Server Error in '/WebGrid' Application....
13
by: Daniel Walzenbach | last post by:
Hi, Imagine the following situation: I have an asp.net application which allows uploading files to a SQL Server 2000 database (Files are stored as type "images"). As a next step I would like to...
0
by: Wayne | last post by:
Original Post: The following problem started on my PC about a week ago and I can't link it to any specific change. I'm using Access XP. If I have any database open and try to open any other...
0
by: Salad | last post by:
A97. Split database. Frontend DB1.MDB. Backend DB1BE.MDB. Tables are linked between DB1 and DB2. From my testing, if I open DB1 exclusively using /excl the backend DB1BE is not opened...
25
by: Andy_Khosravi | last post by:
I just recently changed my database that I'm running from a monolithic DB to a split FE/BE. The front end resides on the client machine and the BE resides on a network drive. I'm experimenting with...
1
by: sunnyluthra1 | last post by:
Hi Everyone, I am working on a piece of code, that displays the properties(Name, Datatype, size & Description) of the table in the database. Now I want to further Enhance the code. I Have created...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
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)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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 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.