N
Nicole
I am trying to create a form using the wizard to compile
information from four separate tables. One of these
tables contains around 50 headings, and the other three
have less than 10 each. If I combine a limited number of
the headings from the large table with the pertinent
headings in the small tables, I am able to open the form
in Form view, Design view and Datasheet view. However, if
I try to put all of the headings from the large table and
the pertinent headings from the small tables, I receive
the message "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. Your form will
be opened in Design view." No one else is accessing the
database. What is the problem?
information from four separate tables. One of these
tables contains around 50 headings, and the other three
have less than 10 each. If I combine a limited number of
the headings from the large table with the pertinent
headings in the small tables, I am able to open the form
in Form view, Design view and Datasheet view. However, if
I try to put all of the headings from the large table and
the pertinent headings from the small tables, I receive
the message "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. Your form will
be opened in Design view." No one else is accessing the
database. What is the problem?