You change the name as you would in any database, but you will also need
to make changes to all the references to the name in both the front ends
and back end.
Just to add to what Joseph says, note that you can have *different*
names in the front and back ends, if that's appropriate. You can right
mouseclick the table name (with the black arrow icon indicating that
it's a linked table) in the frontend, and choose Rename; of course,
you'll need to be sure that all queries, forms, combo boxes etc. which
reference that table are changed to match the new name.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.