Prev: generate_series in ms access
Next: Linked Tables
From: Roberto on 5 May 2010 14:06
Thanks for your suggestion!

"a a r o n . k e m p f @ g m a i l . c o" wrote:

> wow.. welcome to the world of database locking
>
> Access (Jet) doesn't give you the tools you need to fix a problem like
> this
>
> moving to SQL Server / Access Data Projects allows you to use
> QueryHints
>
> THIS CAN RUN EVEN WHEN ANOTHER USER HAS A TABLE LOCK
> Select *
> From employees WITH (NOLOCK)
> Where firstname = 'Aaron'
>
>
>
> On May 4, 10:31 am, Roberto <robe...(a)hotmail.com.ar> wrote:
> > This is the third time I try ti post this question. I hope finally can be
> > readed for somebody.
> >
> > I have an Access 2007 Front End linked with a ODBC driver to a MySQL
> > database in a multiuser environment. I have a problem with a form that shows
> > me the values of a particular table.
> >
> > Until a couple of days ago, when any users deleted a record, it works
> > perfectly. But since yesterday, when anyone tries to delete any record,
> > Access shows a dialog box with the following message:
> >
> > “The Microsoft Office Access database engine stopped the process because you
> > and another user are attempting to change the same data at the same time.”
> >
> > It happens no matter if the record that I was trying to delete is a new
> > record that I am sure that is not been edited by any other person.
> >
> > ¿Can you help me?
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: generate_series in ms access
Next: Linked Tables