Share via

Microsoft Access 2007 Error Message

Anonymous
2010-12-18T17:31:55+00:00

I am tring to create a databhe database with two tables and I am trying to complete the relationship process and "the database engine could not lock table because it is already in use by another person or process'. I am using a computer at my college's resource center. Until I can clear this error I cannot go to the net step

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2010-12-18T17:39:35+00:00

    Make sure that the tables aren't open when you  try to create the relationship. It may help if you close, then reopen the database.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-12-18T23:13:01+00:00

    With the exception (sort of) of Autonumbers , which would be Autonumber vsInteger or Long .

    There's always more than one way to skin a cat!

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2010-12-18T19:29:14+00:00

    Relationships must be between fields of the same type: number vs number or date/time vs date/time or text vs text.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-12-18T19:03:07+00:00

    Ok so I closed the tables and now the error message is Error 3409

    "Invalid field definition "ID" in definition of index or relationship"...now what does that mean???

    Was this answer helpful?

    0 comments
  5. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2010-12-18T18:12:05+00:00

    And when you reopen it, hold down the Shift key so a possible AutoExec macro does not run.

    -Tom. Microsoft Access MVP

    Was this answer helpful?

    0 comments