SQL queries in Access front-end

  • Thread starter Thread starter Tobie
  • Start date Start date
T

Tobie

I have an Access 2000 front-end db that's pointing to a
SQL 2000 db through ODBC.

I need to delete data from some tables, but the Access &
SQL statements differ & so I get a run-time error when
accessing the report.

Access Statement : "DELETE * FROM TMPTABLE" - Doesn't work
in SQL...
SQL Statement : "DELETE FROM TMPTABLE" - Doesn't work in
Access...

Is there any other way I can write this statement??

Thanks!!
 
Hi,


DELETE FROM tableName


should work in Jet (Jet 4.0), with DAO or with ADO, as long as you
delete from a single table (which is a limitation in MS SQL Server that does
not exist in Jet).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top