Form delete error.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lou C - 09 Mar 2007 21:01 GMT

I have set up a form using three db's linked as two sub forms. The are opened
from a single pc by a single user. When attemping to delete the master and
the associated linked records, i get a message that one of the linked records
"is already opened exclusively by another user, or is already open throught
the user interface and cannot be manipulated programmatically". The
relationships allow for cascade deletes. Don't think I have a user interface
(as I don't even know what one is!) Using Access 2000. Any ideas?

Signature

Lou

Reply to this Message

Seth Schwarm - 10 Mar 2007 06:07 GMT

If your links are to data sources other than Access database tables this is
normal. You typically can't delete records from linked table from
applications other than Access.

Seth Schwarm

> I have set up a form using three db's linked as two sub forms. The are opened
> from a single pc by a single user. When attemping to delete the master and
[quoted text clipped - 3 lines]
> relationships allow for cascade deletes. Don't think I have a user interface
> (as I don't even know what one is!) Using Access 2000. Any ideas?

Reply to this Message

Lou C - 10 Mar 2007 15:17 GMT

Seth:
They are access database tables linked thru the form wizard. I run the
parent form and it links the two other table forms. All Access files.
Lou

Signature

Lou

> If your links are to data sources other than Access database tables this is
> normal. You typically can't delete records from linked table from
[quoted text clipped - 9 lines]
> > relationships allow for cascade deletes. Don't think I have a user interface
> > (as I don't even know what one is!) Using Access 2000. Any ideas?

Reply to this Message

Seth Schwarm - 10 Mar 2007 17:21 GMT

Lou C:

Ok, I think from re-reading your post and by reading your new post you don't
have linked tables, but rather your are using the word 'linked' in referring
to the properties of the subform control.

You mentioned you have two subforms, are they by chance showing some of the
same data? Or maybe they both have the same tables in their underlying
queries (if you are using queries)? In both cases I am referring to the
tables on the many side of the relationships.

Seth Schwarm

> Seth:
> They are access database tables linked thru the form wizard. I run the
[quoted text clipped - 14 lines]
> > > relationships allow for cascade deletes. Don't think I have a user interface
> > > (as I don't even know what one is!) Using Access 2000. Any ideas?

Reply to this Message