how to change data source and keep queries
-
hey guys i have a project that uses an ms access database as a data source. and it uses a connection string which specifies the path of the database. now i would like to use that feature where is copies the database to the output directory and uses the new copy as a data source (this is available as a built in option when i create a new data source) but i'd like to apply this feature on my current data source. unfortunately everything i've tried causes either my data source not to work, or renames certain things (like adds a _1 to the name and doesn't reflect on my existing queries) or clears off all the queries on the dataset. does anyone know of a quick and painless method ? hopefully something i overlooked? thanks in advance
Ericos Georgiades