Table relationships

F

fyrman22

I am creating a new database. When I try to enforce referential
intergrity I get an error message that "The database engine could not lock
Table ' ' beacuse it is already in use by another program or proccess." I
investigated this problem, and microsoft indicated they understood this is a
problem. The suggested solutions sounded like I needed to purchase more
sofware. I am using a trial version of office professional. I don't want to
buy $500.00 worth of software if I'm just going to have to purchase more to
fix problems. Am I reading this wrong? Is this a common problem, and is
there another solution?
 
R

Rick Brandt

I am creating a new database. When I try to enforce referential
intergrity I get an error message that "The database engine could not
lock Table ' ' beacuse it is already in use by another program or
proccess." I investigated this problem, and microsoft indicated they
understood this is a problem. The suggested solutions sounded like I
needed to purchase more sofware. I am using a trial version of office
professional. I don't want to buy $500.00 worth of software if I'm just
going to have to purchase more to fix problems. Am I reading this
wrong? Is this a common problem, and is there another solution?
Click to expand...

It's not a problem I've ever heard of. Did you have an queries, forms,
or reports open when you tried this? Are the tables local and not linked?
 
J

Jeanette Cunningham

Hi fyrman22,
in access you can get this message if there is a query open that uses one of
the tables you are trying to create referential integrity for.
The same goes for a form or report.
What happens if you close all queries, forms and reports before you try to
create the referential integrity?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
F

fyrman22

First I closed all of the forms, queries, and reports in the database. When
that didn't work I created a new simple database as a test database with only
two basic tables, and got the same error. It may be that I'm using a trial
version. I use 2003 now and don't have any issues. Thanks for your help. If
you have any suggestions I would appreciate it.
 
Top