When using SQL Server as a back-end, each table should have a RowVersion column. "Link" to these tables in your Access project Use access as a tool to create front-ends for SQL Server / Sybase / Oracle databases! (Note: under no circumstances should you ever promote an application into production that uses the native Access database to store data.) This document tries to help when you find yourself in such a predicament. Nevertheless, there may be times when the customer insists that Access is what they want. I personally believe that Access is an extremely poor choice for creating application front-ends today (Jun 2017), and has been for about twenty years. Microsoft Access Tips Caveat Microsoft Access Tips Caveat It is independent of the data specified by the object's RecordSource. The RowSource property is at the ComboBox or ListBox control level that tells Microsoft Access what data to display for the control. The RecordSource property is a form or report property to populate the data that Microsoft Access displays for that object. Both are properties that can contain a table, query, or SQL string. There is sometimes confusion between the terms RecordSource and RowSource.
0 Comments
Leave a Reply. |