468,765 Members | 1,279 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Access 2003 and SQL Server 2005 Express

Hi,

I tried to migrate data of an Access 2003 application (.mdb) to SQL
Server 2005 Express.
Using the Wizard and choosing 'create a new database', I receive (a
French message saying roughly) '... migration wizard requires SQL
Server version 6.5 sp 5 and later ... connect to an SQL server source
of data.'.

Given that failure, I went to another PC running MSDE (according to
readme file it should be SQL server 2000 service pack 3). Started
migration and it worked just fine. Did some tests and this is really
what we need.

My conclusion has been that Access 2003 has trouble connecting to SQL
Server 2005. Trying to find an answer browsing posted messages, it
sounds like both should connect. Is it just the method I am using that
don't work? The message says that 'the wizard' is not compatible,
is there another way?

I went back to the machine with SQL 2005 and created a small DB using
SQL Client. I started the wizard and this time using the 'use an
existing DB' option but in the end I received the same message.

Is Access 2003 compatible with SQL Server 2005 Express and if so, I
think I need some help about how to do it.

Thank you.

Jun 26 '06 #1
4 5100
On 26 Jun 2006 13:54:48 -0700, jm*****@hotmail.com wrote:

Worked fine for me when I just tried (using the Northwind sample db),
so I don't think it's an inherent problem with Access 2003.
Are you on the latest service packs for Office and SQL Server 2005?
My instance is called <machinename>\SQLEXPRESS. Did you specify the
correct instance name?

-Tom.
Hi,

I tried to migrate data of an Access 2003 application (.mdb) to SQL
Server 2005 Express.
Using the Wizard and choosing 'create a new database', I receive (a
French message saying roughly) '... migration wizard requires SQL
Server version 6.5 sp 5 and later ... connect to an SQL server source
of data.'.

Given that failure, I went to another PC running MSDE (according to
readme file it should be SQL server 2000 service pack 3). Started
migration and it worked just fine. Did some tests and this is really
what we need.

My conclusion has been that Access 2003 has trouble connecting to SQL
Server 2005. Trying to find an answer browsing posted messages, it
sounds like both should connect. Is it just the method I am using that
don't work? The message says that 'the wizard' is not compatible,
is there another way?

I went back to the machine with SQL 2005 and created a small DB using
SQL Client. I started the wizard and this time using the 'use an
existing DB' option but in the end I received the same message.

Is Access 2003 compatible with SQL Server 2005 Express and if so, I
think I need some help about how to do it.

Thank you.


Jun 27 '06 #2
Tom van Stiphout wrote:
On 26 Jun 2006 13:54:48 -0700, jm*****@hotmail.com wrote:

Worked fine for me when I just tried (using the Northwind sample db),
so I don't think it's an inherent problem with Access 2003.
Are you on the latest service packs for Office and SQL Server 2005?


Maybe I am not on the latest SP for Office. Good point, I'll try that.

Thanks.
Jean-Marc.

Jun 27 '06 #3
Just confirming: Been using Access 2003 against SQL Server 2005 for several
months now. No issue found on that score.
Jun 28 '06 #4
If you are trying to transfer a MS Access database to a SQL Server 2005
database, I found this blog to have a good how-to / walk through...
http://cfpayne.wordpress.com/2006/07...l-server-2005/

jm*****@hotmail.com wrote:
Hi,

I tried to migrate data of an Access 2003 application (.mdb) to SQL
Server 2005 Express.
Using the Wizard and choosing 'create a new database', I receive (a
French message saying roughly) '... migration wizard requires SQL
Server version 6.5 sp 5 and later ... connect to an SQL server source
of data.'.

Given that failure, I went to another PC running MSDE (according to
readme file it should be SQL server 2000 service pack 3). Started
migration and it worked just fine. Did some tests and this is really
what we need.

My conclusion has been that Access 2003 has trouble connecting to SQL
Server 2005. Trying to find an answer browsing posted messages, it
sounds like both should connect. Is it just the method I am using that
don't work? The message says that 'the wizard' is not compatible,
is there another way?

I went back to the machine with SQL 2005 and created a small DB using
SQL Client. I started the wizard and this time using the 'use an
existing DB' option but in the end I received the same message.

Is Access 2003 compatible with SQL Server 2005 Express and if so, I
think I need some help about how to do it.

Thank you.
Jul 24 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

33 posts views Thread by Uwe Range | last post: by
92 posts views Thread by Jeffrey P via AccessMonster.com | last post: by
7 posts views Thread by aaa | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.