J
JohnLute
I have a report that displays data from 3 related tables:
tblProfiles
tblPKCGPhysicalAttributes
tblPKCGMaterialAttributes
tblProfiles is related to the other two with one-to-one relationships.
I've place a preview button for the report on frmPKCorrugated which queries
he above listed tables. When I click on this button I'm prompted with a
dialogue box:
"The database engine could not lock 'tblProfiles' because it is already in
use by another person or process."
I'm the only one using the database so that leaves process. I can't imagine
what this means. If I place the same button on my main menu form which
doesn't query anything the n the button works fine.
Why does the button work on the menu but not on frmPKCorrugated?
Thanks for any help you might have!
tblProfiles
tblPKCGPhysicalAttributes
tblPKCGMaterialAttributes
tblProfiles is related to the other two with one-to-one relationships.
I've place a preview button for the report on frmPKCorrugated which queries
he above listed tables. When I click on this button I'm prompted with a
dialogue box:
"The database engine could not lock 'tblProfiles' because it is already in
use by another person or process."
I'm the only one using the database so that leaves process. I can't imagine
what this means. If I place the same button on my main menu form which
doesn't query anything the n the button works fine.
Why does the button work on the menu but not on frmPKCorrugated?
Thanks for any help you might have!