Change table name

[unkamunka]

The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

HTH

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.

[patt]

Try Rick Fishers Find and Replace.