Linked Table is Open

[Guest]

I get the following error message;
The table 'tblLotLane+All' is already opened exclusively by another user, or
it is already openthrough the user interface and cannot be manipulated
programmatically.

Yes I have a master database with a table 'tblLotLane+All'. This table
lists 3600 properties by their address and each property has a unique PropID
number which serves as a primary key.
In my new database I have a table 'tblPropID' that is linked to the table
above.

I have a new form 'frmPropID' that uses a query of the lot number and
street name to locate a specific property and the PropID (Primary key).

I am trying to keep track of some permits issued to each property and my new
database has a table 'tblPermitData' and associated form 'frmPermitData'.

A foreign key on tblPermit data is [fkPropertyID] which I can transfer from
'frmPropID'. I close both forms 'frmPropID' and 'frmPermitData' but when I
try to reopen form 'frmPermit Data' I get the error message listed above.

Can somebody help me cut the tie to the linked table. I dont think I need
it any more becuse I have captured the property number I want in
'tblPermitData' as fkPropertyID.

 

[Guest]

I get the following error message;
The table 'tblLotLane+All' is already opened exclusively by another user, or
it is already openthrough the user interface and cannot be manipulated
programmatically.

Yes I have a master database with a table 'tblLotLane+All'. This table
lists 3600 properties by their address and each property has a unique PropID
number which serves as a primary key.
In my new database I have a table 'tblPropID' that is linked to the table
above.

I have a new form 'frmPropID' that uses a query of the lot number and
street name to locate a specific property and the PropID (Primary key).

I am trying to keep track of some permits issued to each property and my new
database has a table 'tblPermitData' and associated form 'frmPermitData'.

A foreign key on tblPermit data is [fkPropertyID] which I can transfer from
'frmPropID'. I close both forms 'frmPropID' and 'frmPermitData' but when I
try to reopen form 'frmPermit Data' I get the error message listed above.

Can somebody help me cut the tie to the linked table. I dont think I need
it any more becuse I have captured the property number I want in
'tblPermitData' as fkPropertyID.

Tried several variations but the problem persisted. Since I couldn't
resolve the problem I went to Plan "B" - a different code design to avoid the
problem.