Error: 'Training_List' already opened exclusively by another user

[scooteman]

I have a main Form and when I try to open certian other forms while it is open I get the message:

"The table 'Training_List' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."

Is there away to build the record set so this doesn' happen

 

[HiTechCoach]

Is there away to build the record set so this doesn' happen

Sure. Try making the recordset open read-only/snapshot.

 

[boblarson]

Also make sure you aren't using some CONNECTION STRING to connect to the current database. If using DAO use CurrentDb and if using ADO use CurrentProject.Connection.

 

[scooteman]

Sure. Try making the recordset open read-only/snapshot.

That does help

 

[scooteman]

Also make sure you aren't using some CONNECTION STRING to connect to the current database. If using DAO use CurrentDb and if using ADO use CurrentProject.Connection.

Where do I look for those settings?

Also, I am having a problem with my main form that I think is related. I suddenly cannot add anymore buttons to open a form to specific record or change a current macor to open a different form and go to specific records.

If I try to add a buttton with the wizard and choose the selection for finding a specific record, the wizard shows no fields on my main form for matching. I can only add a button for opening a form to all records. How do I fix this.

I tried to recreate the form from the Form Wizard but it gives me the message the it can't view the form becuase the tables is already in use and it opens to design view. I get this eventhough nothing is open.

 

[scooteman]

Where do I look for those settings?

Also, I am having a problem with my main form that I think is related. I suddenly cannot add anymore buttons to open a form to specific record or change a current macor to open a different form and go to specific records.

If I try to add a buttton with the wizard and choose the selection for finding a specific record, the wizard shows no fields on my main form for matching. I can only add a button for opening a form to all records. How do I fix this.

I tried to recreate the form from the Form Wizard but it gives me the message the it can't view the form becuase the tables is already in use and it opens to design view. I get this eventhough nothing is open.

I think I may have found the problem with my main form. I rebuilt it step by step to see when my form lost its recognition of the record source. It seams when I add certian controls to the form, it develops the problem. Right now everything works on the form, so I may leave it the way it is and not worry about it. I am still puzzeld as to why this would happen.