"...database needs to be repaired..." !

[gusbrunston]

Hi:

We're in the midst of preparing September month-end reports. This morning all users got the message: "C:\TCBackEnd\TrelCompBE (our back end) is not an .mdb file or needs to be repaired. Do you want Access to try to repair the database?"

I answered OK and it seems to have worked. My question is, have you had experience with this, and if so, how reliable is the database after MS Access repairs it? I have a backup from late yesterday I could use instead, but it would be an effort to reproduce all the entries made in the last couple hours of the day.

Any advice?

Thanks in advance... Gus Brunston An old PICKer, using Access2000.

 

[CJTyo]

I've had it happen a few times over the years and, after checking my data, found things were fine. Not sure if it's a size issue or not, but I generally started backing up those DB's a couple times a day after that.

Don't take my word for it though, I might have just been lucky!

C *~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception.

 

[TLady]

I do havily repairs and compacts on Access, and my data better be as it use to ... and it is always OK.

Access does not like renaming of variables, changing code etc.
Whenever you feel something weird is happening - compact it.

We use to think Repair unnessesary - compacting is !
but MS combined two of these functions in one in Access2000.

Do not worry, I use it at least 15 times every day.
Average of my databases size 150GB plus plus plus...
TIA

 

[Tootle]

As far as i am aware after such a problem i have had this before and the database seems to be ok afterwards. If you are still not sure try sucking all the tables from your backend into a new database and renaming it. This has also worked for me in the past when i have encountered corruption or problems.

Hope this helps

Andy

 

[gusbrunston]

Hi:

Thanks for all your information.

By the way this was not your ordinary voluntary "compact and repair" but a choice demanded by Access2000.

I found a "new" table in my datbase window named "MSysCompactError".

It listed error codes -1206 and -1053, and both complained that they could not find a field "Description" in one of my tables "tblSecurityDeposits".

The only field named "Description" for that table seems to be in the tables properties...I use it to describe what the table is used for in the database view.

No harm done that I can find.

Thanks for your attention to my post.

Cheers, Gus Brunston An old PICKer, using Access2000.

 

[RacerGirl117]

I get the above referenced error message sporatically in one of my larger databases. It goes days on end running and working fine and then in one day it asks to be repaired several times.

I am running Office/Access 2000 and I've noticed that after I repair this database it inserts queries named like the following:
~sq_cJob Order Main Form~sq_cJO Customers Subform

There is nothing in this query. No tables, no fields. What, if anything, is this supposed to be telling me?

Why do I keep getting the request to repair the database?

I do typically have at least 3 or 4 users performing similar tasks in the database. Could this be part of the problem?

Any help would be appreciated. This always seems to happen at the most inconvenient times.

Thanks,

Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA

http://www.firefighter-pgh.com

 

[gusbrunston]

Hi:

It's been several months since the original post, and when I read your reply, I had forgotten I ever had the problem.

I have set the database to compact and repair on closing. About every two days I ask everyone to log off, and when the last user gets off the database closes and compacts and repairs. I haven't had that error problem since.

Also, I put a command button on the front end menu to back up the data. Whenever a user clicks that button the whole data base is backed up to a cd/rw disk, using Jimmy the Geek's back up program that you can find on this site in the FAQ'S. Note that there are two versions: one using file copy and one not using file copy. The one not using file copy will back up the data while the data file is open. I have it set up so that one backup copy is kept for each day. If a user backs it up in the morning, if it's backed up again in the afternoon, the new back up will replace the one done in the morning. When it's full, the cd goes in the safe. I have daily back ups for the last year.

More than you asked about, and probably less than you need, but I hope this is helpful.

Cheers,





[tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.

 

[RacerGirl117]

I set the database to compact on close this morning. We'll see if it makes a difference.

I do a daily backup of all my databases, albeit manually, that only takes a few minutes. We also do a network tape backup nightly so if I was ever in a real big crunch, I would go there.

Never too much information. Sometimes you ask a question and don't get enough.

Thanks for your help.

Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA

http://www.firefighter-pgh.com