Database Repair Services

Good morning,

I have a client with an Access 2002 database that is giving an Error 3197
upon open (The Microsoft Jet database engine stopped the process because you
and another user are attempting to change the same data at the same time.).

The database is not used in a multiuser environment. I tried compacting
through the built in utility in Access to no avail. I submitted the
database to www.accessdatabaserepair.com (a 3rd party db repair service) and
they returned a report stating that the only thing that could be saved were
the queries.

The client has no backup. (squint eyes and breathe in through clenched
teeth)

Are there other repair services that anyone can recommend or does it look
like all is lost?

Thanks in advance for any help you can provide.

B

Brian,

There's a high probability I can repair the database and make it usable again
for you. If you want my help, contact me at my email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com



"Brian" <someone@microsoft.com> wrote in message
news:tCNPc.659$73.226@lakeread04...[color=blue]
> Good morning,
>
> I have a client with an Access 2002 database that is giving an Error 3197
> upon open (The Microsoft Jet database engine stopped the process because you
> and another user are attempting to change the same data at the same time.).
>
> The database is not used in a multiuser environment. I tried compacting
> through the built in utility in Access to no avail. I submitted the
> database to www.accessdatabaserepair.com (a 3rd party db repair service) and
> they returned a report stating that the only thing that could be saved were
> the queries.
>
> The client has no backup. (squint eyes and breathe in through clenched
> teeth)
>
> Are there other repair services that anyone can recommend or does it look
> like all is lost?
>
> Thanks in advance for any help you can provide.
>
> B
>
>
>[/color]

"Brian" <someone@microsoft.com> wrote in message
news:tCNPc.659$73.226@lakeread04...[color=blue]
> Good morning,
>
> I have a client with an Access 2002 database that is giving an Error 3197
> upon open (The Microsoft Jet database engine stopped the process because[/color]
you[color=blue]
> and another user are attempting to change the same data at the same[/color]
time.).[color=blue]
>
> The database is not used in a multiuser environment. I tried compacting
> through the built in utility in Access to no avail. I submitted the
> database to www.accessdatabaserepair.com (a 3rd party db repair service)[/color]
and[color=blue]
> they returned a report stating that the only thing that could be saved[/color]
were[color=blue]
> the queries.
>
> The client has no backup. (squint eyes and breathe in through clenched
> teeth)
>
> Are there other repair services that anyone can recommend or does it look
> like all is lost?
>
> Thanks in advance for any help you can provide.
>[/color]


http://www.pksolutions.com/

"Brian" <someone@microsoft.com> wrote:
[color=blue]
>I have a client with an Access 2002 database that is giving an Error 3197
>upon open (The Microsoft Jet database engine stopped the process because you
>and another user are attempting to change the same data at the same time.).
>
>The database is not used in a multiuser environment. I tried compacting
>through the built in utility in Access to no avail. I submitted the
>database to www.accessdatabaserepair.com (a 3rd party db repair service) and
>they returned a report stating that the only thing that could be saved were
>the queries.
>
>The client has no backup. (squint eyes and breathe in through clenched
>teeth)
>
>Are there other repair services that anyone can recommend or does it look
>like all is lost?[/color]

There are other things you can try. Such as importing into a new MDB, using ODBC and
such.

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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

"Brian" <someone@microsoft.com> wrote in message news:<tCNPc.659$73.226@lakeread04>...[color=blue]
> Good morning,
>
> I have a client with an Access 2002 database that is giving an Error 3197
> upon open (The Microsoft Jet database engine stopped the process because you
> and another user are attempting to change the same data at the same time.).
>
> The database is not used in a multiuser environment. I tried compacting
> through the built in utility in Access to no avail. I submitted the
> database to www.accessdatabaserepair.com (a 3rd party db repair service) and
> they returned a report stating that the only thing that could be saved were
> the queries.
>
> The client has no backup. (squint eyes and breathe in through clenched
> teeth)
>
> Are there other repair services that anyone can recommend or does it look
> like all is lost?
>
> Thanks in advance for any help you can provide.
>
> B[/color]


One trick is to open a new database, different name. Then import all
the objects of the "bad" database. This will leave behind, usually,
all the bad stuff and will let you know which objects didn't import
(the bad objects). If it isn't too many, just rebuild those objects.
Usually it is one object. This also compacts the database and is a
great way to compact overlarge or baulky databases. I've used this
many times.