
Signature
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
> I'm using Access 2003. How do I unlock a table ?
>
[quoted text clipped - 49 lines]
>
> Make sens ?
thanks, but it does not help. the table is still locked, in fact it is not
related to my code I have done the following test :
Table1 with one Field
AAAAA
BBBBB
CCCC
Form1 with a combo list where the record source is field1 of table1. Open
the form but do not select any item from the combo list. Try to delete the
table1 it is ok. Now, select an item from the combo list and then try to
delette the table. Access returns a message that the engine icannot lock the
table as it is used by another process. any way to wrod this around ?
Also, if I have the form open and then I add a row in my table, how do I
refresh the list in the combo without closing the form ?
> rst.close
> set rst = nothing
[quoted text clipped - 57 lines]
> >
> > Make sens ?
[MVP] S.Clark - 21 Nov 2005 23:47 GMT
For first ?: What is the combobox's rowsource... Table or Query?
comboboxname.requery is the answer to your second question.
> thanks, but it does not help. the table is still locked, in fact it is
> not
[quoted text clipped - 80 lines]
>> >
>> > Make sens ?