Search results

Hi, I'm trying to delete a table once I've used it and always get the same error saying that the table is already in use, these are the commands I've tried: DB.TableDefs.Delete ("Report") AND strSQL = "DROP TABLE Report" DB.Execute (strSQL) Can't figure out how to avoid this. Please help Mike

Hi, I'm trying to create a new table from another existing two in vba. I'm using this code without success... Any help will be gratefully taken. --------------------- Dim strSQL as string Dim tablaSuma As DAO.TableDef Dim rst As DAO.Recordset strSQL = "SELECT * FROM Necesidades_TRS1, Pedidos...