Error message when trying to open a 2nd from based on same table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magicdds - 06 Apr 2008 17:47 GMT

I have a form opened and I want to open a second form (while the first form
remains open) that is based on the same table. When trying to open the second
form, I get an error message that says:

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

I can't figure out what setting I set incorrectly. Does anyone know how to
correct this problem?

Reply to this Message

boblarson - 07 Apr 2008 03:46 GMT

Why would you need to have a 2nd form based on the same table? It doesn't
make sense and it really isn't good to do. If you provide your reasoning as
to what you are actually trying to accomplish, we might have a better
suggestion.

Signature

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________

> I have a form opened and I want to open a second form (while the first form
> remains open) that is based on the same table. When trying to open the second
[quoted text clipped - 5 lines]
> I can't figure out what setting I set incorrectly. Does anyone know how to
> correct this problem?

Reply to this Message