PC Review


Reply
Thread Tools Rate Thread

How can I fix broken Access database

 
 
=?Utf-8?B?Sm9zZXBo?=
Guest
Posts: n/a
 
      30th Mar 2007
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
 
Reply With Quote
 
 
 
 
'69 Camaro
Guest
Posts: n/a
 
      30th Mar 2007
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/ex...ributors2.html for contact
info.


"Joseph" <(E-Mail Removed)> wrote in message
news:5CCE6B17-5F2F-4EC7-803C-(E-Mail Removed)...
> 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



 
Reply With Quote
 
'69 Camaro
Guest
Posts: n/a
 
      30th Mar 2007
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/ex...ributors2.html for contact
info.


"'69 Camaro" <(E-Mail Removed)_SPAM> wrote in
message news:(E-Mail Removed)...
> 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/ex...ributors2.html for contact
> info.
>
>
> "Joseph" <(E-Mail Removed)> wrote in message
> news:5CCE6B17-5F2F-4EC7-803C-(E-Mail Removed)...
>> 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

>
>




 
Reply With Quote
 
=?Utf-8?B?Sm9zZXBo?=
Guest
Posts: n/a
 
      30th Mar 2007
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" wrote:

> 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/ex...ributors2.html for contact
> info.
>
>
> "Joseph" <(E-Mail Removed)> wrote in message
> news:5CCE6B17-5F2F-4EC7-803C-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
'69 Camaro
Guest
Posts: n/a
 
      30th Mar 2007
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/ex...ributors2.html for contact
info.


"Joseph" <(E-Mail Removed)> wrote in message
newsFF3BB11-E9A5-4C9E-BCED-(E-Mail Removed)...
> 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" wrote:
>
>> 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/ex...ributors2.html for contact
>> info.
>>
>>
>> "Joseph" <(E-Mail Removed)> wrote in message
>> news:5CCE6B17-5F2F-4EC7-803C-(E-Mail Removed)...
>> > 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

>>
>>
>>



 
Reply With Quote
 
aaron.kempf@gmail.com
Guest
Posts: n/a
 
      30th Mar 2007
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.


On Mar 30, 12:10 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAM> wrote:
> 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
>
> Seehttp://www.QBuilt.comfor all your database needs.
> Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
> Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
> info.
>
> "Joseph" <Jos...@discussions.microsoft.com> wrote in message
>
> newsFF3BB11-E9A5-4C9E-BCED-(E-Mail Removed)...
>
>
>
> > 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" wrote:

>
> >> 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

>
> >> Seehttp://www.QBuilt.comfor all your database needs.
> >> Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
> >> Blogs:http://www.DataDevilDog.BlogSpot.com...s.BlogSpot.com
> >>http://www.Access.QBuilt.com/html/ex...utors2.htmlfor contact
> >> info.

>
> >> "Joseph" <Jos...@discussions.microsoft.com> wrote in message
> >>news:5CCE6B17-5F2F-4EC7-803C-(E-Mail Removed)...
> >> > 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- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
aaron.kempf@gmail.com
Guest
Posts: n/a
 
      30th Mar 2007
Access Data Projects work _GREAT_

MDB is for losers and retards


On Mar 30, 12:10 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAM> wrote:
> 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
>
> Seehttp://www.QBuilt.comfor all your database needs.
> Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
> Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
> info.
>
> "Joseph" <Jos...@discussions.microsoft.com> wrote in message
>
> newsFF3BB11-E9A5-4C9E-BCED-(E-Mail Removed)...
>
>
>
> > 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" wrote:

>
> >> 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

>
> >> Seehttp://www.QBuilt.comfor all your database needs.
> >> Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
> >> Blogs:http://www.DataDevilDog.BlogSpot.com...s.BlogSpot.com
> >>http://www.Access.QBuilt.com/html/ex...utors2.htmlfor contact
> >> info.

>
> >> "Joseph" <Jos...@discussions.microsoft.com> wrote in message
> >>news:5CCE6B17-5F2F-4EC7-803C-(E-Mail Removed)...
> >> > 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- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
Tony Toews [MVP]
Guest
Posts: n/a
 
      31st Mar 2007
A a r o n K e m p f wrote:

>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
 
Reply With Quote
 
Tony Toews [MVP]
Guest
Posts: n/a
 
      31st Mar 2007
"Tony Toews [MVP]" <(E-Mail Removed)> wrote:

>A a r o n K e m p f wrote:
>
>>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.


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
 
Reply With Quote
 
David W. Fenton
Guest
Posts: n/a
 
      31st Mar 2007
"'69 Camaro" <(E-Mail Removed)_SPAM>
wrote in news:(E-Mail Removed):

> Microsoft Access data recovery services are expensive.


Peter Miller at pksolutions.com is *not* expensive. If the data is
worth anything at all, it's worth a couple hundred bucks to recover!

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inking in Access 2007 and broken links after transfer database on Vista SAM Microsoft Access 9 19th Feb 2008 12:15 PM
Inking in Access 2007 and broken links after transfer database on Vista SAM Microsoft Access Forms 0 14th Feb 2008 05:45 PM
Inking in Access and broken links after transfer database on Vista mij via AccessMonster.com Microsoft Access Forms 0 14th Feb 2008 04:46 AM
I Have a broken Access XP database asking for a MSysdb file?????? =?Utf-8?B?TEQ=?= Microsoft Access 1 16th Sep 2006 08:30 PM
How do I fix a missing or broken reference in an Access database? =?Utf-8?B?UnVieUFuZ2VsNjI=?= Microsoft Access 1 27th Mar 2006 07:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:16 PM.