Linked Table is Open

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Paddler said:
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.
Click to expand...
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.
 
Back
Top