I have an MSDE engine i connect to it using ADO. i have a databse that contain user records on my local drive. i want from time to time to select certain records and backup them into CD or DVD. but at the same time i can use the database(backup) on the CD or DVD to browse and look for users records beside my local database, so i can use both databases for browsing. how can i do that.
Im using vc++ with ado to connect to sql server desktop edition engine