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. 4 5268
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.
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.
Just confirming: Been using Access 2003 against SQL Server 2005 for several
months now. No issue found on that score.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Matt Alanzo |
last post by:
Our SOHO 2 person compay sells furniture (not programmers). In '98 we
paid $,$$$ for a VBA -Access '97 accounting application, including VBA
source code .... an huge investment for us then (and...
|
by: Matt Alanzo |
last post by:
On another newsgroup an Access knowledgable party posted:
>You should be able to connect an Access ADP to an existing SQLExpress
>database running in SQLS 2000 compatibility mode. The only thing...
|
by: Uwe Range |
last post by:
Hi to all!
A customer of mine told me some days ago that her IT-people told her
ACCESS would not be such a good idea for continuing with our project,
because Access will not be continued in the...
|
by: Jeffrey P via AccessMonster.com |
last post by:
Our IT guys are on a vendetta against MS Access (and Lotus Notes but they've
won that fight). What I can't understand is, what's the problem? Why does
IT hate MS Access so much.
I have tried...
|
by: Praveen |
last post by:
Hi All,
I have made a webservice in C# and it works fine in my machine. I ran into a
crazy problem when I wanted to deploy it in windows 2003 server. I have run
"aspnet_regiis.exe -i" to make...
|
by: Neil |
last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL
Server to SQL 2005, and are considering upgrading to Access 2003. Someone
mentioned that they had heard about some...
|
by: RayPower |
last post by:
I'm having a system using Access 2000 as both front-end (queries,
forms, reports & temp tables for reports) & back-end (data) with
back-end running on the server. The application runs on the...
|
by: aaa |
last post by:
I have a problem connecting .net 2003 (framework 1.1) with
sql express 2005 (framework 2.0)
What is the problem:
definitions or compatibility?
|
by: Ted |
last post by:
I am working on two versions of an application, one of which will be a
windows forms application (which will need to be redistributable) and
the other will be a web application.
I have MS Visual...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |