If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|