Hi,
Can anyone help me regarding a Access 2007 application i have, i want to seperate the data from " The Access Program", where i can send the user a new Program without the data. and i can test the program without seeing the confidential data at the customers site.

Do i just copy the program, remove all the Vb stuff and forms and save the app as say Database.mdb then use the original to import data from this "New" Database.mdb ?

Thanks

Colin

I just posted links here:

http://www.access-programmers.co.uk/forums/showthread.php?t=157101

Spot on, Thanks very much