Access 2007 New Form - Source Table Open In Exclusive mode

[iain]

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

 

[Jerry Whittle]

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.

 

[iain]

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