How can I fix broken Access database

[Joseph]

My Office Access 2003 SP2 got corrupted and upon openning shows the message:
The Microsoft jet database engine could not find the object 'MSysDB'. Make
sure the object exists and you spell its name and the path name correctly.
I've tried to use Compact and Repair utility but it got the same message
with openning the corrupted file.
I also tried to import to empty database all of the object but with the same
message and result.
Can anybody help me with this?
Thanks,
Joseph

 

['69 Camaro]

Hi, Joseph.

Can anybody help me with this?

Restore from last night's backup. You do have a backup, don't you?

Next time you run into a corruption problem, make a copy of the file and
work on the copy. Compact/repair the copy or use JetComp on the copy.
Sometimes JetComp can repair a database when compact/repair can't, because
JetComp doesn't first open the database file like compact/repair does.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Hi, Joseph.

In case you need JetComp, you can find a link to it in the "Free Microsoft
Access Troubleshooting Tools" section of the following Web page:

http://www.access.qbuilt.com/html/links.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Joseph]

Thanks.
Yes I did restore from yesterday's backup but users lost data they entered
today and I am looking for the way to help them. I just tried the JetComp
utility but it did not help either.
Thanks again.

 

['69 Camaro]

Hi, Joseph.

Yes I did restore from yesterday's backup but users lost data they entered
today and I am looking for the way to help them.

Microsoft Access data recovery services are expensive. If your organization
can't afford to lose data that was input since the last backup, then the
data should be migrated to a client/server database such as Oracle or SQL
Server, which are much more robust and can restore recent transactions from
the transaction log whenever something goes wrong.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[aaron.kempf]

your organization can't afford to lose data then the
data should be migrated to a client/server database such as Oracle or
SQL
Server, which are much more robust and can restore recent transactions
from
the transaction log whenever something goes wrong.

 

[aaron.kempf]

Access Data Projects work _GREAT_

MDB is for losers and retards

 

[Tony Toews [MVP]]

your organization can't afford to lose data then the
data should be migrated to a client/server database such as Oracle or
SQL
Server, which are much more robust and can restore recent transactions
from
the transaction log whenever something goes wrong.

Agreed.

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

 

[Tony Toews [MVP]]

Agreed.

No, Aaron didn't write that. Gunny did.

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

 

['69 Camaro]

Hi, David.

If the data is
worth anything at all, it's worth a couple hundred bucks to recover!

Very true! I was "speaking" relatively. A couple hundred bucks compared to
the cost of the time taken to make a backup and restore from the backup is
far more expensive than I would care to pay.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[David W. Fenton]

Hi, David.


Very true! I was "speaking" relatively. A couple hundred bucks
compared to the cost of the time taken to make a backup and
restore from the backup is far more expensive than I would care to
pay.

But did he not say he had a backup? And the problem was the lost
data that the users had entered between the backup and the
corruption? The cost of re-entering the data may be much more than
the recovery cost.

 

['69 Camaro]

Hi, David.

But did he not say he had a backup?

Yes. He's fortunate to have a backup.

The cost of re-entering the data may be much more than
the recovery cost.

If that's the case, then the data needs to be stored in a client/server
database, not a file-based database that has no built-in recovery method.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[aaron.kempf]

the time necessary to move to SQL Server is trivial, at best

performance gains are worth it; every single scenario

 

[aaron.kempf]

f u kid

I was emphasizing what he said.


if your organization can't afford to lose data then the data should
be migrated to a client/server database such as Oracle or SQL Server,
which are much more robust and can restore recent transactions from
the transaction log whenever something goes wrong.