Once the process has been completed, you can build interfaces and queries to the linked tables just as you would for any Access database.
When a query is requested on a table within Access, ODBC is used to execute the queries on the My SQL database.
By the end of the first lesson, you will know how to use the basic JDBC API to create tables, insert values into them, query the tables, retrieve the results of the queries, and update the tables.
In this process, you will learn how to use simple statements and prepared statements, and you will see an example of a stored procedure.
Hi, Were doing a hospital admin system where the hospital admin can enter a new patients details and save them to a ms access DB. We must have the ability to SELECT, ADD, DELETE and UPDATE the Db.
So far we have managed 3 but cannot figure out how to Update the DB.