Database Won't Repair!
Dec 2, 2005
This morning when I got into work, one of the databases I admin died. It has since locked itself open stating it needs to be repaired. However, when you try to, it says it is locked open by machine......However, that machine has been restarted many times and it is still locked open. The database is located on a shared drive. I am assuming that the network drive has locked it open instead of that PC.
Would someone explain why that has happened? As well as how to stop that from happening in the future. This is very frustrating since I have to change other things that are driven by that database, due to the name of the database changing for a short time. Once I can delete the corrupted one, I have to change them back.
View Replies
ADVERTISEMENT
Jan 26, 2006
I have an Access 2002 database that won't compact and repair. When I attempt to open it, it tells me that the database is corrupted and needs to be repaired. When I try to repair it, it gives me the following message: Could not find field 'Description'. Then, the next message states that the db cannot be repaired or isn't an Access db. I've downloaded the JetComp.exe tool, but it gives me the message: Error compacting database. I've tried creating a new database and then importing the objects from the corrupted one, but that failed as well. Any advise?
Isharmonic
View 11 Replies
View Related
Nov 22, 2004
Hello guys and gals,
Please could you help me.
My bosses computer hung whilst he had a database open, now on trying to open it again, Access tells us that it needs repair.
When we say yes try to repair Access tells us invalid password,, the DB is password protected on open.
I notice that there is an .ldb file in the folder, is this anything to do with our problem?
Could you tell me if there is any way to retrieve this database?
He doesn't have a current copy.
Please help if you can.
Thanks,
Brian.
Zimbabwe.
View 6 Replies
View Related
Jan 9, 2004
I get message "MS Acces was unexpectedly quit while MS Acces databse was open. Repair database Y/N? " When I try to open the password protected database. I click yes and get an "invalid password" message. Is there anything I can do to get round this or do I just need to use a back-up?
View 4 Replies
View Related
Jan 31, 2006
Hi,
I was wondering if anyone might be able to help me. What i'd like to do is to be able to get the access to trigger compact and repair database tool automatically just before it shuts. Is it feasible? or has to be done manually?
Thank you in advance
View 2 Replies
View Related
Feb 24, 2006
We have a database that users are writing to through an excel form. We have been successfully writing to this for months however we have now run into a problem...
We have tried opening the database outside of the timeframe that users can write to it and are getting an error:
"The Database R:...mdb' needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want to repair the database?
The problem is:
1. The excel form that writes to the database still works. This form inserts a row into a table and then checks that this record exists. When we insert a record the ldb files last updated time changes to the present time.
2. We tried zipping the database, unloading it on a different server and then repairing it. This worked however none of the records insert over the past few days are existant, and the database descreases significantly in size.
I believe the records are in the database as we can still write to it through the excel form which is checking that the record is properly inserted.
Any ideas on how we can recover this data? I tried running a spreadsheet that would select everything from the table but received an error when trying to connect to the database.
View 4 Replies
View Related
Apr 17, 2007
The compact and repair utility is very good.
Since all my record operations are done through menu, I would like to put a command button for this utility also. But I dont know how to do this. Would somebody help? Thanks in advance.
View 2 Replies
View Related
Mar 17, 2008
Hi all,
I ahve come across a small problem and i am wandering if someone can helo me out on this.
I have a programme which is for the fast food and uses a order no for each receipt, now the problem is each time the form is closed and opened the number goes to the next avaialable number so last nunber was 32 the next will be 33 etc this number adding is done by code but i am having a problem somewhere along the lines and it goes back to 1 every so often, so the you have to log off and log in to to to the next available record,
So i was thinking rather having to do the number increment by code why not have a auto number field in there instead, the only problem is at the end of the day the number should go back to 1 for the next day so is there a way to compact and repair the database or better still to zero the tables i wish??
Thank you
Regards
Naym
View 2 Replies
View Related
Jun 30, 2005
How can I recover a curropt database. I know it is possible as a few softwares were able to recover it and they are just a Demo. Does anyone know a freeware available.
Its a matter of urgency.. please help!!!!
View 6 Replies
View Related
Aug 3, 2007
Is it possible to make the database compact and repair itself when it is closed to prevent it becoming too large?
Alternatively, can you create a macro to compact and repair at the click of a button?
Thanks, Steve
View 2 Replies
View Related
Feb 9, 2008
Can anyone give me guidance or code on how to automatically compact and repair.
There is something going on in my database when I open and it goes from 3.7kb to 26 kb each time it is opened - I cant find out why - ope to the why suggestion but another option is to automatically compact and repair
Thanks in anticipation.
Humph
View 2 Replies
View Related
Jun 4, 2014
I created a database for my Dad's farm and it was all going well until I have been away for a while. I ensured the DB was backed up properly before I left but he didn't know how to back it up himself apparently so now we are in trouble.
Anyway, one day he went to open the DB and got the "unrecognized database format" message and the file doesn't open at all. The DB was created in Access 2013 and has only ever been used in 2013 (though my Dad uses runtime as he doesn't have a full license like me).
There is a couple of months worth of data which would cause a real headache if it was lost so fixing the file is the best outcome if at all possible, I tried the "compact and repair" from inside access without the DB opened but got the same message. I noticed that there is 3rd party software online claiming to fix all access files but they sound a little too good to be true and a good source of infecting my computer with a virus.
View 9 Replies
View Related
Jan 13, 2006
Goodmorining,
I use Access XP and I have a problem with the Compact and Repair function.
When I start this function via the normal menu's access doesn't seem to respond anymore. I can leave my comp on for hours dut nothing happens.
He does make a copy (db1) with the same volume but then it stops.
Does anybody else has this problem and what can I do about it
Thanks
Kind regards
Rolf
View 1 Replies
View Related
Jan 17, 2006
Hi
does anyone know how i would make my database compact & repair itself either when i open or close it?
tried to do it via a macro but it says that it can't compact and repair when a macro is running :(
:confused:
View 14 Replies
View Related
May 23, 2006
Hi all,
This morning i opened up my database, it worked fine, ie could add new records on to the forms etc but when i went to look at my tables, queries, forms etc nothing was there and an error message about indexes came up.
I had a look through this forum and found a lot of useful information on compacting and repair. I compacted my database and it went from 89KB to creating a new database with only 28KB. The new one which it created works perfect for me and i have deleted my old one, as still no tables, queries etc showed up.
I didn't even have a clue i should have been compacting my database regularly, stupid i know but we all learn. My question is, when looking at threads i have noticed that when people talk about compacting, repair is mentioned too, do i need to run the repair tool now on my database? Or is it ok. Im not entirely sure of its function, i will keep looking though, Thanks for any replys :)
View 11 Replies
View Related
Jul 25, 2006
Hi guys,
This is just for discussion really. What does Compact and Repair actually do? If I was to set my database to compact and repair on close, am I in danger of losing any data, formatting on forms or anything? What are the pros and cons?
I would really appreciate some replies. Thank you in advance :)
View 6 Replies
View Related
Dec 28, 2006
When I 'compact and repair' on my office computer, two tables' autonumber fields become corrupt (I get a duplicate autonumber)
I took the original .mdb home and 'compact and repaired' it at home and to my surprise the tables didn't become corrupt.
Any ideas why the compaction causes errors in the office but not in my home?
Thanks very much
View 2 Replies
View Related
Jan 30, 2007
Hi,
Could anyone explain to me what compact and repair actually does? Made a backup copy of my database and did the c and r and reduced the size greatly! Has it lost data? Just would be good to understand how this works.
Thanks
Sam
View 2 Replies
View Related
Feb 26, 2007
I have a macro that will copy the database to a folder upon quiting.
The databse also is enabled from the options to compact and repair upon exit.
Problem is the copied databse will be always not compacted becaue the macro will run 1st before quiting (and hence before compacting).
is there a way around it
View 5 Replies
View Related
Mar 8, 2007
I have search the post and I found several articles about compacting and repair the DB. I just installed 2007. So you think that had an issue with compacting. Before I installed 2007 I had no problems at all. I even tried to import tables, forms and etc. into a new DB. I get error messages there as well.
I can say when I was working in 2007. I had to open the 2007 DB in exclusive. As of now I am just fishing for answers.
Bottom line I must have done something while working in 2007.
Any Ideas would help.
PS. I can go into the db with no problem at all, which is really strange. But when I create a new DB I can't import any of the tables or forms.
View 4 Replies
View Related
Nov 17, 2007
This is a very general question. so I am not sure if it has been asked before.
I know that compact and repair can sometimes fix problems with the database.
Should it be done only when problems seem to be creeping in? Or should this be done on a regular basis - say once a week or once a month?
View 14 Replies
View Related
Dec 28, 2007
Can compact and repair be set up to run either on a specified day of the week (for example every Monday), or day of the month (for example the first of each month)?
Alternatively can I have it run automatically when the database is closed?
If so, how would it be done?
I am using A2003 with Windows XP.
View 11 Replies
View Related
Apr 18, 2007
Okay... unlike my last post (although unintentional), this is legitimate.
Whenever I do a compact and repair on my database, access crashes and offers to attempt to repair my db. IF I allow it to do that, it will blow away all of my VBA code and so everything stops working.
If i uncheck the repair box, access will just close. I can reopen my db myself and it's find. I'm not sure about any repairs (never understood, what it's repairing), but it's definately compacted any everything is fine.
So why does it crash and why does it eat my db unless i uncheck the box upon crashing?
View 1 Replies
View Related
Feb 10, 2005
I have built a DB in Access 2002 which includes an automated Compact and Repair button. My problem is that the DB, (I have just found out) must run on 97. The code I am using is as follows:
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction
This is producing an error in 97 because, I belive, the compact and repair are two seperate headings. Can someone advise me where I'm going wrong or even correct my code for me? Thanks!
View 6 Replies
View Related
Feb 23, 2005
I understand how to compact and repair and also the fact that you need to do it so that you can increase the efficiency of your database, but my question is why? I have a database that is used fairly heavily all day by 4 to 5 users. At the beginning of the day the file is about 91 mb, by the end of the day the file size is about 133 mb. Why does it grow so much in just an 8 hour period? What causes access to need to be compacted and repaired?
View 2 Replies
View Related
Jan 26, 2006
I have an Access database that's on our in-house server. This database has never been compacted/repaired. Recently our server crashed (but we were able to retrieve the database). Does the fact that the database has not been compacted have anything to do with the server crashing? Could that have affected it in any way?
Also, how often should the database be compacted/repaired?
Thanks for your help!
View 7 Replies
View Related
