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!
4  5702 
restore it from your last backup. (you do backup daily, don't you?)
ba**********@ya hoo.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
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**********@y ahoo.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.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!
In article <11************ **********@g43g 2000cwa.googleg roups.com>, ba**********@ya hoo.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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 ?
-----------------------------------------------------------------------------
Open source database server company MySQL's next production release of
its open source MySQL database server will be sporting a new Windows
installer, one partially built with an open source project courtesy...
|
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 less complex technical
calculations, several input variables. I would like to equipp the
starting panel with the usual New, Open, Save, Save As, Close etc.
menus (like in Excel, or Word, etc.) What is the best way to
accomplish Save, or Save As?...
|
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 Excel charts in unbound object frames. When I add 3
additional subreports, I get the error message that Access can't open any more
databases. Can anyone suggest what may be causing the error message.
Thanks!
|
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 think my problem
mainly lies in knowing the quirks of the Access object model.
Basically, I'm looking for a method of determining if an Access database
is open yet. AND I'm looking for a method that doesn't not require
checking for an...
|
by: vvenk |
last post by:
Hello:
When I tried to use an Access database, I get the following exception:
Server Error in '/WebGrid' Application.
--------------------------------------------------------------------------------
The Microsoft Jet database engine cannot open the file 'D:\Program
Files\Infragistics\NetAdvantage 2005 Volume
2\ASP.NET\Samples\Data\samplebrowser.mdb'. It is already opened exclusively
| | |
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 implement some way to enable
downloading those files from the database which leads me
to the following two problems:
1.) How can I create a file "in memory" as I don't want to
create temporary files stored on my web server and
|
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 database by
double clicking its file in Explorer, it takes about 5 seconds to open.
Previously the second database would open almost instantaneously, as
one would expect on a reasonably fast machine.
|
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 exclusively.
If I open DB1 but have no tables open and then open up DB1BE
exclusively, DB1BE will open exclusive. But if I then attempt to open a
linked table in the frontend DB1 I'm informed I can't use the table
because the file is in use.
|
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 a utility
developed by Tony Toews to handle the distribution and subsequent
updates of the software. I'm having some trouble with the overall
upgrade process I've implemented, and I'm hoping one of you may have
an idea how to go about fixing...
|
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 a form in MS Access, on that form, I have 2 buttons & a text box.
One button is to select a mdb file, whom properties i want to display. Second button then stores that properties in a Excel file.
when I open the file using first button, the path of...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
