. . . 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,
Dan
Convert, downsize, SQL Server database to Microsoft Access
Hot Topic
- INSERT and SELECT in one SP
- How is SQL Server Loosing Saved Data?
- Getting "extremely complex query" error when using xml data type parameters
- Dataset cannot be generated error
- Foreach NodeList Enumerator
- SSIS Script component for data conversion
- Snapshot replication - Primary key not transferred
- using package variables as parameters in Execute Sql Task
- SSIS package configuration issue
- About Login Account
SQL Server
- SQL 2005 Replication Error authenticating proxy
- design for passing data between layers?
- Where is SQL Server Management Studio?
- Dynamic Scripting for USE [DB]
- Error "Msg 6522, Level 16, State 1" receives when call the assembly from Store Procedure to create a Text file and to Write text
- Active (non executed) objects will still drain performance!?
- Linked servers and Windows Authentication
- GACing components
- SQL server installation, books online trouble
- Launching the Reports From Browser
Convert, downsize, SQL Server database to Microsoft Access
Jan R
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.
AndySuwandy
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