Help: database corruption

Hi all,

I have a coruupted database because of a problem in one of the memo fields.

I get: The Microsoft Jet database engine stopped the process because you
and another user are attempting to change the same data at the same time.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6070-help-database-corruption.html

I am using Access 2003.

I need quick help.

Thanks for answers

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Veli Izzet wrote:
> Hi all,
>
> I have a coruupted database because of a problem in one of the memo
> fields.
> I get: The Microsoft Jet database engine stopped the process because
> you and another user are attempting to change the same data at the
> same time.
> I am using Access 2003.
>
> I need quick help.
>
> Thanks for answers

For a start you can take a look at: http://allenbrowne.com/ser-47.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6070
scroll down to the memo field corruption area.

I can also add that you may be able to recover (note always work on a
copy of your database) if you can open the table and find the odd entries
and delete the record before and after. For some reason some memo field
corruptions seem to display the corruption in a good records data.

I will also suggest that memo fields seem to be subject to more problems
than text fields in some applications. I suggest using text fields if
possible. Text fields also take up less room.

--
Joseph Meehan

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6070
Dia duit

Hi,

We had the same error message, and it caused our data to be mysteriously
replaced with oriental writing. The cause of the error turned out to be
write conflicts, i.e. one user has a record open and another user tries to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6070
make changes. You should then get a warning message that tells you of the
write conflict and offers options. In my experience it's always better to
drop the changes and start again.

You can also cause a write conflict yourself if you have two forms open at
once that both relate to the same underlying table.

Another thing that might help is to regularly compact and repair your
database. Other than that, I'm afraid I don't have a clue!

Good luck.

"Veli Izzet" wrote:

> Hi all,
>
> I have a coruupted database because of a problem in one of the memo fields.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6070
>
> I get: The Microsoft Jet database engine stopped the process because you
> and another user are attempting to change the same data at the same time.
>
> I am using Access 2003.
>
> I need quick help.
>
> Thanks for answers
>

Veli Izzet wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6070

>I have a coruupted database because of a problem in one of the memo fields.
>
>I get: The Microsoft Jet database engine stopped the process because you
>and another user are attempting to change the same data at the same time.

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corr...uptrecords.htm
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6070

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