V
VanSLO
I am curently working with an access 2000 database. I am having a problem
with this query:
SELECT DetDocs.*, DocFax.*
FROM DetDocs LEFT JOIN DocFax ON DetDocs.DDID = DocFax.DFCPrID;
When I attempt to add a record for the above query, it allows me to create a
record. However, when I attempt to save the record, I get the following
error: "Could not read; currently locked by user '(My User Name)' on machine
'(My Computer's Name)'." It essentially is telling me that it can't read the
record because I'm using it. Does anyone have any idea why this is happening?
NOTE: for some reason, some of the relationships in the back end do not
appear as external relationships in the front end. I was told that this is
alright, and that they will be enforced anyway. I'm not sure if it is a
related issue, but the problem only seems to occur in queries affected by
these "invisible" relationships.
with this query:
SELECT DetDocs.*, DocFax.*
FROM DetDocs LEFT JOIN DocFax ON DetDocs.DDID = DocFax.DFCPrID;
When I attempt to add a record for the above query, it allows me to create a
record. However, when I attempt to save the record, I get the following
error: "Could not read; currently locked by user '(My User Name)' on machine
'(My Computer's Name)'." It essentially is telling me that it can't read the
record because I'm using it. Does anyone have any idea why this is happening?
NOTE: for some reason, some of the relationships in the back end do not
appear as external relationships in the front end. I was told that this is
alright, and that they will be enforced anyway. I'm not sure if it is a
related issue, but the problem only seems to occur in queries affected by
these "invisible" relationships.