I have an application that uses Acces as a backend and VBA as front end. Application is secured and is supplied on a CD with setup.exe.
Can I use VB 2005 and MS SQL to achieve the same?
Would I be able to package my application with all the neccessery files (assuming that client does not have any e.g. SQL server) so that multiple front ends can access data from common source?
Would I be able to secure such an application using only VS 2005?
What would I need to quickly learn how to achieve the above ( any books you can suggest maybe)?
You can absolutely use SQL Server Express to ship as part of your application - it is designed for that. You can find a whitepaper with guidance on this at http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp. The whitepaper includes an explanation of how you can use a feature called ClickOnce in Visual Studio/.NET to deploy your client applications. You should also sign up for redistribution rights for Express at http://www.microsoft.com/sql/editions/express/redistregister.mspx.
Thanks< MJ
No comments:
Post a Comment