SQL queries in Access front-end

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!!
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access front end and sql server back end 6
How do I execute multiple SQL statements in Access?? 3
Access 2010 append query to SQL is very slow 0
SQL server backend 2
Calling Parameterized Query Using SQL Syntax 3
Support for CASE statements in SQL 2
Comment Lines in MS Access SQL 3
Query not working for SQL Server 2

Top