What's the difference between SQL mode and table mode when I use the command dbopen()?

I want to make connection to the access database.But in the command dbopen(), I don't understand the difference between SQL mode and table mode.
What's the difference between SQL mode and table mode when I use the command dbopen()?
If someone can tell me ,I will appreciate very much.
Thanks.

In table mode the whole table is opened and the cells can be edited. In SQL mode a SELECT query may only return a subset of a table and the cells cannot be edited.

SQL mode can be more versatile as you can: select just the records you want; perform joins between two or more tables; perform table operations on the database (including CREATE and ALTER), and perform transformations on the data fields as part of the query process.

Thank you Jason.
Now I am developing a model which I want to write to a database and also read from the database. At the same time, my colleague uses C# to visit the access database too. But when I debug the model, the error appears.
The error is:Microsoft Office Access database engine has stopped the process, because you and other users are trying to change the unified data at the same time. Driver: [Microsoft][ODBC Microsoft Access Driver] FlexSim Code: 23 - SQLSetPos
What can I do for avoiding the error?

Try organizing your data so that Flexsim reads from some table and writes to others. That way you shouldn't run into problems with the other application trying to write to 'Flexsim's' tables. If you need to view a mix of this read and write data then create views in Access or via SQL for that.

If you absolutely need to have concurrent writes to the same tables I think you'll need something with one or a mixture of: table locking, transaction processing/rollback/commit, calling stored procedures and/or mutual exclusivity (mutex). Also check the DB driver allows concurrent sessions. A.J. might have some more ideas.