How to run SQL queries in MDB files?

Question

I need to run an UPDATE query on a large MDB file (~ 30 MB), is this possible? as?

Answer 1

As Remu said, use the query constructor.

Once you are there, you can drag and drop as you like.

If you really want to inject SQL directly, you can. You can switch from the Design view to the SQL view and manually enter it.

SQL MS Access. , , , , MS Access. MS Access . "*" (ANSI-89) .mdb .accdb, "%", ANSI-92 SQL ( .adp - Access Data Projects). , ANSI-89 Access -.mdb .accdb. ANSI-92 Access - , Microsoft SQL Server.

MySQL. MS Access - , . . ANSI-89 SQL ANSI-92 SQL ( ).