View Single Post
  #1  
Old May 15th, 2010, 12:12 AM posted to microsoft.public.access.forms
JeanRNorman
external usenet poster
 
Posts: 1
Default Wizard unable to open form in Form or Datasheet view

I am just learning Access, and I am unable to get a Form to work with my
database. I get an error, "The wizard is unable to open your form in Form
view or Datasheet view, possibly because another user has a source table open
in exclusive mode." I am the only one working on this database, which is
brand-new. I found one Help article that said if a "reserved word" was used,
that could cause a problem like this, and I had done that on my first try.

I created the form based on two tables, "Facilities" and "Activities", that
are in a one-to-many relationship ("Facilities" is the many, "Activities" the
one).
I deleted that database and started a fresh one with the same name but not
using that reserved word, thinking that would fix the problem. It has not.
I cannot enter data in fields bound to the "Facilities" table, but I can to
fields bound to the "Activities" table. When I try to type in the
"Facilities"-bound fields, I get a brief message at the bottom of the screen
that says, "join key of Facilities not in record set."

Can you help?