The database engine could not lock table (table name) because it

Hello,

I have two table that are joined on a one to one join type, referrential integrity is enforced.

Then I designed a query from my table to provide customers that match a certain criteria in a date range. This has parameter fields that let the person choose the date on which data they need to search.

From that I have then designed a report based on the query, this then displays the query in a more presentable format.

I have then included a command button as a link to the form and when it is pressed the above error appears. But, when I exit the form I can run the report in the Objects pane with no problems. There is something conflicting somewhere, but I have used this technique in the past and it has worked. I need this for a corportate database that I am designing so a response would be appreciated as soon as possible.

Thanks,

Gary

RE: The database engine could not lock table (table name) becaus

The Title should have read as above!