Leszynski naming convention

Since the Leszynski naming convention is a special form of Hungarian notation the same general advantages also apply to the Leszynski convention. The use of distinctive prefixes makes your database self-documenting; when you see frmSales in VBA code, you will know that it references a form, and when you see curSales you will know that it is a Currency variable. When selecting a query from a drop-down list, you will know that a query starting with qmak is a make-table query, while one starting with quni is a union query. This information will allow you to avoid errors such as using the SetFocus method (a control method) with a field, or trying to open a table. ==Disadvantages==

• Since the Leszynski naming convention is a special form of Hungarian notation the same general disadvantages also apply to the Leszynski convention. • Changes in database design may require wholesale renaming. For example, replacing a table with a query would involve either retaining the tbl name for the query, or going through the entire database replacing the tbl name with a query name. • When transferring the database to a different DBMS, problems will arise if the target DBMS does not support CamelCase names. • As every object of the same type starts with the same letter, it is not possible to navigate through the objects in a List box by typing the beginning letter. ==Elements==

The elements of the naming convention are described in the following table. The Basic LNC Object Prefixes The Basic LNC Variable Prefixes The Basic LNC Database Object Tags The LNC Table Field Tags The LNC Tags for VBA Variables The LNC Tags for Form and Report Controls Some Typical LNC Names for Database Objects, Controls and Variables ==References==