Updating all tables in a microsoft access database using dreamweaver
The linked table appears in the list with a small world globe icon: When you double-click the icon, it behaves just like a local table in the database file. The changes are saved in the My SQL database as soon as you move to another record - no need to save or re-export the table.Access tables and My SQL tables do not behave in exactly the same way.
You may export data to My SQL as described above, and you can also import a My SQL table into an Access database.The following work-around is suggested by the My SQL manual: After exporting your table to My SQL, use php My Admin to make the field "auto-increment" - you do this using the "change" option on the page that shows the table's structure. You can then make the link from Access to the table.When you add new rows to the table, leave the auto-increment field and timestamp field blank - My SQL fills them in for you.In both cases, you use the SQL statement INSERT INTO to accomplish the task.INSERT INTO statements are commonly referred to as append queries.Select the table that you want to link, and click OK: In this example, the name of the table "Students" is already in use, so a new name is automatically given to the linked table.
You can rename or delete a linked table without affecting the database on the My SQL server.
To modify the data that is currently in a table, you use the UPDATE statement, which is commonly referred to as an update query.
The UPDATE statement can modify one or more records and generally takes this form: To delete the data that is currently in a table, you use the DELETE statement, which is commonly referred to as a delete query. The DELETE statement can remove one or more records from a table and generally takes this form: The DELETE statement does not remove the table structure—only the data that is currently being held by the table structure.
There are essentially two methods for adding records to a table.
The first is to add one record at a time; the second is to add many records at a time.
This provides very convenient mechanisms for both populating your database initially, and for keeping it up to date.