RE: [MS_AccessPros] Error 3211

Phucon,
I expect someone might have the table open. Your question doesn't suggest otherwise.

Duane Hookom MVP
MS Access

________________________________
> From: saigonf7q5@yahoo.com
>
> 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/