Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • Thread starter Thread starter Tim J
  • Start date Start date
T

Tim J

I am getting run-time error 3008

'The table (TableName) is already open exclusively by
another user, or it is already open through the user
interface and cannot be manipulated programmatically.'

I get this when trying to open the form in code from any
other form that has a record source.

If my current form has no record source then the other
form opens fine.

here is the code

Forms![Back].[MainCheck] = False

DoCmd.OpenForm "Cands", acNormal, "", "", , acNormal

DoCmd.Close acForm, Forms![Back].[CrntFrm]
Forms![Back].CrntFrm = "Cands"

The error occurs on the form open line.

Again, I only get the error when running the code from a
form the has a record source, else it works.


Any Ideas?

TIA,
TimJ
 
What is the Record Source of the "Cands" form? Is it the same as the form
that is opening it? Or is it using a table that is also in the opening
form's RecordSource?

Are any of the forms' Record Locks properties set to All Records or Edited
Record? Set them to No Locks instead.
 
Back
Top