Tuesday, March 20, 2012

Convert, downsize, SQL Server database to Microsoft Access

. . . I know, WHY would I want to do this?! Well I like to develop databases in SQLServer, but there is a chance that when I transition this database to the client, they will only have Access at their disposal. Hence before I begin creating the database in SQL Server, I would like to know if it's easy to convert to Access should the need arise.

Thank you in advance,

DanRegards.
Why Access?

Convertion to SQL Server 2005 Express would be so much easier. Smaller chance of client changing things, also.

Just one warning from the license:
http://download.microsoft.com/download/8/9/1/891cf345-643c-49a7-98bc-58bc04def37a/SQLServer2005ExpressEdnDistributionLicense.rtf

3. INTERNET-BASED SERVICES. Microsoft provides Internet-based services with the software. It may change or cancel them at any time
|||

Good point. As for why Access, the one IT person in the office uses Access, and I don't think it will be in my scope to switch her to SQL Server or even SQL Server express.

No comments:

Post a Comment