Table relationships

  • Thread starter Thread starter fyrman22
  • Start date Start date
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?
 
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?
 
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
 
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.
 
Back
Top