Hi Astro,
Tables and queries must have unique names; you cannot use the same name for
a table and a query. I'm not sure exactly what sequence of steps that you are
taking, because I am able to attempt to name a table the same as a copied
query name, although Access prevents this duplication of names.
Are you having to create a lot of new tables? If so, why? This does not seem
like a good database design.
My suggestion is to use relatively short, but descriptive, names for the
objects displayed in Access (tables, queries, forms, reports, macros, DAP's
and modules). You should include the use of a naming convention, and avoid
the use of special characters (spaces, # signs, etc.) and reserved words. You
will come to appreciate this suggestion if/when you start writing VBA code
and have to reference these object names. Here are some links to help you
start using naming conventions:
Naming Conventions
Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp
Using a Naming Conventio
http://msdn.microsoft.com/library/d...us/odeopg/html/deconusingnamingconvention.asp
Reserved Words
Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335
List of reserved words in Jet 4.0
http://support.microsoft.com/?id=321266
Tom
______________________________________
:
In older versions of Access you could copy a name from a query and paste it
in when naming a table from the query? In 2002 you can copy the query name,
but "What's this" is the only option that comes up with a right clicking in
the new table name box.
Has anyone figured out a way to do this? We use long names and it's a pain
to retype the whole thing...
