Can I use SQL+ in Access 2000

[Guest]

I am taking SQL/Oracle in a db Management course at RIT in Rochester, NY. I
am practicing DML & TCO statements using MS Access 2000. Each time I enter a
command I get a popup window saying if I enter the command I can't rollback.
I want to be able to practice all of these Transaction Control Operations:
Commit, Rollback, and Save Point.

I appreciate any assistance.

 

[Guest]

I am taking SQL/Oracle in a db Management course at RIT in Rochester, NY. I
am practicing DML & TCO statements using MS Access 2000.

Access, Oracle, and SQL/Server each have their own distinct dialects of the
SQL language; none of them comply fully with the SQL ANSI standard.

In particular, while you can use COMMIT and ROLLBACK operations in
Access2000, you must do so in VBA code - NOT in SQL statements. They're
simply not recognized terms. If your database backend is in ORACLE you can
create "passthrough" queries in ORACLE SQL - but they are not legal in the
JET (native Access) database engine.

John W. Vinson/MVP