naming convention

[Antonio]

Ive been using access for about 6 months now. When I
began, I knew nothing of the naming conventions for the
different parts of my database. Is their an easy way to
change the names of each of the tbl's, frm's, qry's, and
rpt's, in my database? I attempted to do it manually,
following the path of each of the qry's rpt's, but its
proven very difficult since the database is has grown to
be quite big...

 

[Albert D. Kallal]

The real problem is not the renaming, but if you have any code. When you
re-name a table, or rename a form, then all of the code, queries and all
kinds of things that references those forms needs to be changed.

There is a feature in a2000 (track name autocorrect) that is supposed to
handle all of this, but I can't vouch for it.

Basically, this means that if you re-name something, you can break your
code. You need to use MUCH caution in changing names.

I would as rule start using some naming convention, but you probably should
just leave your existing forms etc alone unless you really know the
application well.