Hi
Thanks for the replys.
As the application has already been designed from the ground up for use with the Access database I would rather stick with this as the backend database.
I have had a look at SSIS for SQL 2008 unfortuantly to use the Business Intelligence Development Studio I need to have SQL 2008 Professional which you get the developer edition with and unfortuantly I only have SQL 2008 Standard. I think I am going to have to look into writing my own VB program that sits as a service on the clients PC and updates the SQL Server Manually.
Regards
Dj