Migrate Access 2002 to SQL Express 2005

Hot Topic

How to implement this scenario
Service Broker Tables
Problem with Incrementing variable
I can't deploy a Cube
process cube
Swapping partitions in SSAS 2005
matrix report
Business Scorecard Integration with SQL server 2000/2005
SQLCMD "-r" option
More errors in convert function

SQL Server

Table Variables in Stored Procedure
Upgrade/migrate to new hardware. What's best?
OLE DB Source & SQL Command
Deployment worked when it shouldn't have done
Reporting Services Login Error
rsExecutionNotFound when using ASP State Server
Two Instances (SQLEXPRESS and MSSQLSERVER)
General network error. Check your network documentation
Transfer SQL Server Objects Errors
can't open adventure works example

Migrate Access 2002 to SQL Express 2005

Hello

I'm trying to migrate my access mdb (XP version) to SqlExpress 2005. I use Updating wizzard from Access and i get an error saying that my sql server is not compatible and that i have to use SQL 6,5 SP 5 or later. What i'm doing wrong


Answer this question

Migrate Access 2002 to SQL Express 2005

  • GregorHagedorn

    I believe that you are right but this feature is not supported in SQL Express
    Thanks

  • Belliez

    Well you can download demo version of the full sql server 2005.  Perhaps you should look at purchasing the developer version or an MSDN subscription to get the tools you need.

  • agnerc

    The best way to migrate your data would be to use the new integration services in sql server 2005.  However, I'm not sure what Express edition offers in this way.

  • windperson

    This is possible but not in the default configuration.  See the blog post at http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx for more info on how to configure to do this.  Thanks< MJ

  • Migrate Access 2002 to SQL Express 2005
Answer this question