June 11, 2009 at 6:08 am
I have a project develop a database loaded with a significant amount of data. I plan to use SQL Server 2005 with an Access 2003 front end. The customer would like the read-only data -- complete with the data, forms, reports and whatever else they need -- delivered via CD / DVD.
I am new to SQL Server and I am trying to figure out the best approach to provide the deliverable. We do not have control of the computers they will be running it from (no SQL Server licensing). Is there a way to create a package that will be usable on an unlicensed workstation? We are willing to purchase the required licensing, but can they run from the CD / DVD??
June 12, 2009 at 12:16 am
Both Access and SQL Server require write access to the drives they run from so running from CD/DVD won't work.
I haven't used Access for a long time but you used to have to purchase the runtime option in order to package up an Access database/frontend to give to a customer who hasn't got an Access licence - the packaged application would then be installed on the customer machine and provides the ability to run Access without the design elements.
As for SQL Server, they will need a licence unless you use SQL Express which is free but has a 4Gb limit.
June 12, 2009 at 12:49 am
You don't need to control read only access from hardware level. If your Access front end uses a SQL login that has "read only" access to your data then so be it. By the way, there are external HD with lots of storage that suits your needs. If external HD is not an option, what about USB flash?
June 13, 2009 at 8:27 am
You can also set read only option on database. Right click database -> Properties -> Options -> Database Read-Only
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply