So I don't want any update if a pic already exists and no other pic has been entered into the file fields. I have been told that it is possible to do this using sql but can't find solution.
Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
Large updates become much easier to perform when you understand some of the basic principles of database design.
In some cases, you can use conversion functions to perform calculations on the data in a Text field.
You can enter large amounts of text and numeric data in this type of field.
The following table lists the data types that Office Access 2007 provides and describes how they affect data entry.Show me how to view data types Access now provides two ways to view the data types for a table field.You can use the commands on the Datasheet tab, or you can open the table in Design view.How to repeat: Install My SQL 4.0.14-standard on Free BSD 4.6 and then either with the command-line client or PHP/Perl DBI send an UPDATE statement which updates more than 1 field in a table. Suggested fix: -Can you provide us with a repeatable test case - table schema (CREATE TABLE statements), minimal current records in the table, the exact UPDATE syntax you're trying to run? No feedback was provided for this bug for over a month, so it is being suspended automatically.If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".