Syntax Error in FROM clause

[clloyd]

So you are saying the code would read as follows:

Dim MyDB As Database  
Set MyDB =OpenDatabase "S:\Current\Montey's Restaurant, Inc\Montey's Restaurant\Montey's Restaurant.mdb'")  
MyDb.Close

I have numerous tables in this database. I still do not understand how it knows which table to delete from reading the code as I have it above. I am not an expert so if I am missing something I apologize.

[clloyd]

I went ahead and tried it removing MyDB.Execute "DELETE FROM MyTable" and still got the Invalid SQL Statement; expected 'Delete', 'Insert', 'Procedure', 'Select', or 'Update' error

[debasisdas]

I think in your code MyTable is the name of the table.

[clloyd]

No matter what I do this code does not work. I will keep searching.

[debasisdas]

do you understand the code ,you have written
I don't think you understand the difference between a database and a table.
Please use ADO and follow as per post#8

[clloyd]

No I don't understand post 8. I am not an expert programmer. I do understand however the difference between a table and a database though. That was a little harsh.

[debasisdas]

try something like this

Dim CON As New ADODB.Connection 
  
Private Sub Command1_Click() 
CON.Open "Provider=MSDAORA.1;Password=DEBASIS;User ID=DEBASIS;Data Source=DAS;Persist Security Info=True" --change to your own connectionstring
CON.BEGINTRANS
CON.EXECUTE "DELETE FROM TABLE1"  --USE YOUR DELETE STATMENT HERE
CON.COMMITTRANS
Endsub

[QVeen72]

Hi

Where are you writing the Code..? in VB6 or in VBA...?

Regards
Veena

[clloyd]

VBA. Sorry to take so long I was on other projects.