RE: [MS_AccessPros] Error 3211

Phucon,

I don't know if it's just me but I don't see your replies until I click the reply.

If the table is local then tell us if it's you that has the table open. Can you delete the table manually? 

Duane Hookom MVP
MS Access

________________________________
> From: saigonf7q5@yahoo.com
>
> Hi Duane, it's local table.
>
> ---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote:
>
> Phucon,
> I expect someone might have the table open. Your question doesn't
> suggest otherwise.
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: saigonf7q5@...<mailto:saigonf7q5@...>
>>
>> When the cmdRun button is click, it runs this Sub:
>>
>> Private Sub cmdRun_Click()
>> More code here
>> .
>> DoCmd.Hourglass True
>> db.TableDefs.Delete "tblTable1" 'deleting existing table
>> db.Execute strSql, dbFailOnError 'and creating new table with most
>> current data
>> DoCmd.Hourglass False
>> More code here
>> .
>> End sub
>>
>> It had been running ok. Then sudden, it only runs the first time, if
>> the cmdRun is clicked again, it will generate the "Error 3211 The
>> database engine could not lock table 'tblTable1' because it is arlready
>> in use by another person or process."
>>
>> I have to close the form, or close the application, even reboot to get
>> it back to work.
>>
>> What's the possible cause? ?
>>
>> Phucon

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/