Making relationships between two tables in Microsoft Access

%3CLINGO-SUB%20id%3D%22lingo-sub-1426554%22%20slang%3D%22en-US%22%3EMaking%20relationships%20between%20two%20tables%20in%20Microsoft%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426554%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%20I've%20been%20learning%20about%20how%20to%20use%20Microsoft%20Access%20and%20until%26nbsp%3B%20a%20few%20weeks%20I%20was%20getting%20on%20fine%20making%20relationships%20between%20two%20tables.%20The%20it%20started%20coming%20up%20with%20a%20message%20that%20said%20I%20had%20to%20close%20a%20table%20being%20used%20by%20an%20other%20person%20in%20order%20to%20create%20the%20relationship.%20I%20have%20only%20the%20computer%20I'm%20working%20on%20at%20home%20and%20I%20have%20even%20deleted%20other%20tables%20that%20I%20was%20using%20to%20practice%20on%20before%20I%20started%20again.%20The%20message%20is%20called%20error%203211.%20I've%20tried%20compact%20and%20repair%20also%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Hope%20somebody%20can%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Rita%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1426554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426657%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20relationships%20between%20two%20tables%20in%20Microsoft%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683462%22%20target%3D%22_blank%22%3E%40Margaritaz_225%3C%2FA%3E%26nbsp%3BDo%20you%20open%20one%20or%20both%20of%20the%20tables%20in%20datasheet%20view%20before%20trying%20to%20enforce%20Referential%20Integrity%3F%20If%20so%2C%20that's%20the%20problem.%20If%20not%2C%20what%20about%20forms%20or%20queries%20using%20those%20tables%3F%20Also%20closed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

   I've been learning about how to use Microsoft Access and until  a few weeks I was getting on fine making relationships between two tables. The it started coming up with a message that said I had to close a table being used by an other person in order to create the relationship. I have only the computer I'm working on at home and I have even deleted other tables that I was using to practice on before I started again. The message is called error 3211. I've tried compact and repair also

 

                          Hope somebody can help

                                        Rita

1 Reply
Highlighted

@Margaritaz_225 Do you open one or both of the tables in datasheet view before trying to enforce Referential Integrity? If so, that's the problem. If not, what about forms or queries using those tables? Also closed?