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
________________________________
I expect someone might have the table open. Your question doesn't suggest otherwise.
Duane Hookom MVP
MS Access
________________________________
> From: 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
>
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar