When trying to create a new form from a query using multiple tables I get an
error message when the form opens stating that the error is "possibly due to
another user having a source table open in exclusive mode".

It is a single user application and the default is set to shared.

Does anyone know what could cause this error?

Thanks

It's possible that you have something like a deadlock or contention issue
where you are joining the multiple tables in such a way that locks them up.
You should try to join the tables in the same way as they are joined in the
Relationships window. If they aren't joined there with Referiential Integrity
enabled, all bets are off.

Post the SQL statement for the query here. Maybe someone will see something
obvious.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"iain" wrote:

> When trying to create a new form from a query using multiple tables I get an
> error message when the form opens stating that the error is "possibly due to
> another user having a source table open in exclusive mode".
>
> It is a single user application and the default is set to shared.
>
> Does anyone know what could cause this error?
>
> Thanks

Thanks for the tip however my problem has arrisen from using multiple queries
as the record source for a form. In this case two queries made use of the
same table.

Thanks

"Jerry Whittle" wrote:

> It's possible that you have something like a deadlock or contention issue
> where you are joining the multiple tables in such a way that locks them up.
> You should try to join the tables in the same way as they are joined in the
> Relationships window. If they aren't joined there with Referiential Integrity
> enabled, all bets are off.
>
> Post the SQL statement for the query here. Maybe someone will see something
> obvious.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "iain" wrote:
>
> > When trying to create a new form from a query using multiple tables I get an
> > error message when the form opens stating that the error is "possibly due to
> > another user having a source table open in exclusive mode".
> >
> > It is a single user application and the default is set to shared.
> >
> > Does anyone know what could cause this error?
> >
> > Thanks