Tell us what property of the querydef object can you use to change the SQL syntax?
Submitted by: MuhammadSQL property. If you declare a qdf variable and assign it to a query, you can change the syntax of the sql statement using qdf.sql = “Select…”. One interesting feature of this property: You don't have to save the changes, they are immediately saved. Compare that with the DAO recordset object where you must use the Edit method followed by Update in order to save your changes.
Submitted by: Muhammad
Submitted by: Muhammad
Read Online Microsoft Access Developer Job Interview Questions And Answers
Top Microsoft Access Developer Questions
☺ | Tell us what property does every object in MS Access have? |
☺ | What are managing Data Tasks? |
☺ | Tell us how Do You Create An Append Query? |
☺ | Tell us About The Various Features Present In Ms Access? |
☺ | Tell us what format should my database be saved in to allow different versions of Microsoft Access to open the database? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |