Delete * from a Table in Another Database

[Fattire]

Can I call this 'delete records query' below to delete all the records in a table that resides in another access DB? Both databases reside on the same shared drive.

del = "Delete * from tblInvoices"
rst.Execute del, Con

 

[Remou]

It depends on what con is.

 

[PWise]

del = "Delete * from tblInvoices in 'c:\xxx\xxx\xxx.mdb'"
rst.Execute del, Con

or you can link the table

 

[Fattire]

Yes Remou I wasn't being clear there...

pwise your suggestion worked, thank you, that would have taken me forever to figure out. Here's what it ended up being:

Private Sub cmdPurgeMainTable1_InMainDB_Click()

Dim rst As ADODB.Recordset
Dim con As ADODB.Connection
Set con = CurrentProject.Connection

del = "delete * from tblMainTable1 in 'C:\Main.mdb'"
con.Execute del

End Sub

 

[Remou]

You could have said:

[tt]strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\main.mdb;"
con.Open strCon

del = "delete * from tblMainTable1"
con.Execute del[/tt]