On Jul 31, 11:52 pm, mray29 wrote:
Congrats on using naming conventions! In my view tbl is a sufficient prefix
for a table name. I don't think it's necessary to have table types in the
prefix. Tables only have one function, to hold data, so all tables are
essentially equal. If you do decidd to use special naming conventions for
lookup tables, etc., as long as you're consistent it doesn't matter which one
you pick.

FWIW see the "Level 2 tags" in the following MSDEN article:

Naming Conventions for Microsoft Access
http://msdn.microsoft.com/archive/de...n_20naming.asp

Jamie.

--