stopped the application

[Florin]

Hi,

When I open an application in access97, I get the message:

" 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 verify and that problem is in a query.
I am sure : don't exist another user witch open this application.

Can any one tell me about this error?

Thanks

[Stefan Hoffmann]

hi Florin,

Florin wrote:
> " 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 verify and that problem is in a query.
> I am sure : don't exist another user witch open this application.
> Can any one tell me about this error?

Check whether all your tables used by this particular query have primary
keys.

The most common reason for this message is the fact that Access/Jet
checks the data before updating. It does by using a SQL which uses all
fields in the WHERE clause. Due to rounding issues this check may fail,
when inaccurate data types are used (especially when the primary key
consists of such data types, e.g. single or double).

mfG
--> stefan <--