Unspecified Error

[yagnik3128]

I am using VB 6.0 with access

at this line of coding

mainconn.execute "Delte * from Table1"

I got the error

Run time error : 02147467259(80004005)
Unspecified error.

Can anybody help me how to solve it?

 

[cLFlaVA]

You have [tt]DELETE[/tt] spelled wrong, but I assume that's just a typo on the forum.

I assume you're trying to delete all rows in the table. Try:

[tt]DELETE FROM Table1[/tt]

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!

 

[zemp]

Could it be that 'Delete' is misspelled, or is that just a typo in the post?

zemp

 

[yagnik3128]

Yes its a typo mistake.

It is not giving the error every time. there is a where condition also.

 

[rsinj]

having checked a few other resources, this appears to be a sharing violation error at least in some instances.

are any other users or programs accessing the database at the same time? try opening the database in shared mode and/or make sure nobody else has the table locked at the time you are doing your delete *.