If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 New Form - Source Table Open In Exclusive mode
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 |
#2
|
|||
|
|||
Access 2007 New Form - Source Table Open In Exclusive mode
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 |
#3
|
|||
|
|||
Access 2007 New Form - Source Table Open In Exclusive mode
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 |
Thread Tools | |
Display Modes | |
|
|