Hi Guys,

I have to forms frmContacts (Unbound / ADO) and frmJobTitle (Bound to tblJobTitle)

1) On my frmContacts I have a field cboJobTitle and the Row Source is the tblJobTitle and Limit to List = Yes
2) If the JobTitle is not available on the list, by double-clicking the cboJobTitle the frmJobTitle will open in acFormAdd to add a
new job title. I'm closing this frmJobTitle by just clicking the X button.

DoCmd.OpenForm "frmJobTitle", acNormal, , , acFormAdd

Once I get back to my frmContacts the newly job title created is already on the list, which is fine. But when I tried to
double-click again the cboJobTitle its giving me an error:

Run-time error '3008':
The table 'tblJobTitle' is already opened exclusively by another user, or its already open through the user interface and cannot be
manipulated programmatically.

I'm only the one using the db and I'm sure the tblJobTitle is not used except the row source of my cboJobTitle. Do you think that
cause the problem or my approach was wrong?

Any help would be highly appreciated...

TIA,
GeOrGe

Did you remember to close the recordset for the table in frmJobTitle?  Is
that form opening the table exclusively?

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Wednesday, January 15, 2003 9:44 PM
|To: Access
|Subject: [access] TABLE Open Exclusively
|
|
|
|Hi Guys,
|
|I have to forms frmContacts (Unbound / ADO) and frmJobTitle (Bound
|to tblJobTitle)
|
|1) On my frmContacts I have a field cboJobTitle and the Row Source
|is the tblJobTitle and Limit to List = Yes
|2) If the JobTitle is not available on the list, by
|double-clicking the cboJobTitle the frmJobTitle will open in
|acFormAdd to add a
|new job title. I'm closing this frmJobTitle by just clicking the X button.
|
|DoCmd.OpenForm "frmJobTitle", acNormal, , , acFormAdd
|
|Once I get back to my frmContacts the newly job title created is
|already on the list, which is fine. But when I tried to
|double-click again the cboJobTitle its giving me an error:
|
|Run-time error '3008':
|The table 'tblJobTitle' is already opened exclusively by another
|user, or its already open through the user interface and cannot be
|manipulated programmatically.
|
|I'm only the one using the db and I'm sure the tblJobTitle is not
|used except the row source of my cboJobTitle. Do you think that
|cause the problem or my approach was wrong?
|
|Any help would be highly appreciated...
|
|TIA,
|GeOrGe
|
|

Thanks Leo, here's my comments :
The frmJobTitle is bound to tblJobTitle so there's no opening and closing of rs.
Any more idea?

TIA,
George


> -----Original Message-----
> From: Leo Scott [mailto:leoscott@c...]
> Sent: Friday, January 17, 2003 9:12 AM
> To: Access
> Subject: [access] RE: TABLE Open Exclusively
> 
> 
> Did you remember to close the recordset for the table in frmJobTitle?  Is
> that form opening the table exclusively?
> 
> |-----Original Message-----
> |From: George Oro [mailto:george@c...]
> |Sent: Wednesday, January 15, 2003 9:44 PM
> |To: Access
> |Subject: [access] TABLE Open Exclusively
> |
> |
> |
> |Hi Guys,
> |
> |I have to forms frmContacts (Unbound / ADO) and frmJobTitle (Bound
> |to tblJobTitle)
> |
> |1) On my frmContacts I have a field cboJobTitle and the Row Source
> |is the tblJobTitle and Limit to List = Yes
> |2) If the JobTitle is not available on the list, by
> |double-clicking the cboJobTitle the frmJobTitle will open in
> |acFormAdd to add a
> |new job title. I'm closing this frmJobTitle by just clicking the X button.
> |
> |DoCmd.OpenForm "frmJobTitle", acNormal, , , acFormAdd
> |
> |Once I get back to my frmContacts the newly job title created is
> |already on the list, which is fine. But when I tried to
> |double-click again the cboJobTitle its giving me an error:
> |
> |Run-time error '3008':
> |The table 'tblJobTitle' is already opened exclusively by another
> |user, or its already open through the user interface and cannot be
> |manipulated programmatically.
> |
> |I'm only the one using the db and I'm sure the tblJobTitle is not
> |used except the row source of my cboJobTitle. Do you think that
> |cause the problem or my approach was wrong?
> |
> |Any help would be highly appreciated...
> |
> |TIA,
> |GeOrGe
> |
> |
> 
> 
>