[MS_AccessPros] Error 3211

 

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 (1)

Recent Activity:

• New Members 5

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___