Easy way to change DSN for the same report???

[Guest_imported]

I'm try to use to different servers with pre-existing reports that specify a certain DSN. I can't change the DSN server because it is continously be used but I have other apps that need to be directed to a different server. Is this possible without removing the tables and adding a new DSN????

 

[MalcolmW]

Add a new DSN, and point the report to it with Database|Set Location will avoid removing the tables. Is that what you are looking for?