You just need DELETE FROM table, forget the "*"
Here is a sample of finding tables to in a database:

[CODE=vb]'Using ADO
Private ConDB As ADODB.Connectio n
Private rs As ADODB.Recordset
Private ProviderType As String
'Make sure you know the Provider versions
'PSI = "True" if there is a password to get into the database else "False"

'MS Access: ProviderType...

Just in the last few months, I have had problems with Shell in VB6. Depending what your program was doing before the "Shell" statement can effect it. Formerly, your current directory followed the shell statement. I believe it to be a Microsoft patch. I can run a compiled program on one of our servers that works fine. If I recompile the exact same code, shell no longer runs correctly. Now, it seems to execute without changing the directory....