upsizing wizard access 2000 MSDE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne Harper - 17 Oct 2004 22:22 GMT

I have access 2000 9.0.6926 sp-3
I just installed the latest MSDE. I know its working because other
applications can use it.
I can create a new project with an EXISTING database on the server,
but I cant use the upsizing wizard.
it says: "[dnetlib][connecttionopen(connect()).]sql server does not
exist or access denied "
then: "the upsizing wizard only works with microsoft sql server
(version 6.50 sps or higher) please log in to a sql server data
source"
Does the upsizing wizard for access 2000 not work with MSDE?
(please let me know if this isnt the appropriate group for this
question)
-Wayne

Reply to this Message

Mary Chipman - 18 Oct 2004 14:48 GMT

There's problems with the 2000 upwiz due to the fact that Access 2000
was released well before SQLS 2000. See How to Convert an Access
Database to SQL Server
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237980 for
more info and troubleshooting.

--Mary

>I have access 2000 9.0.6926 sp-3
>I just installed the latest MSDE. I know its working because other
[quoted text clipped - 10 lines]
>question)
>-Wayne

Reply to this Message

Wayne Harper - 18 Oct 2004 19:47 GMT

Thanks but I dont see anything in that link that addresses the errors
I received.

Also, it says:
"In Access 2000, on the File menu, point to New, and then click New
Project from Existing Database"
At point in the upsizing process are you supposed to do this?

-Wayne

> There's problems with the 2000 upwiz due to the fact that Access 2000
> was released well before SQLS 2000. See How to Convert an Access
[quoted text clipped - 3 lines]
>
> --Mary

Reply to this Message

Mary Chipman - 19 Oct 2004 17:28 GMT

There are many reasons the upsizing wizard fails, not least of which
is due to the fact that Access 2000 is older than SQLS 2000, i.e., it
was designed to work with SQLS 7, not later versions. So you have
failures for data type exceptions, data ranges, bad data, and so
forth. If you use Access a lot with SQL Server 2000, I'd recommend
upgrading to Access 2003. I'd even go further and recommend that you
not rely on the upsizing wizard even when it does work. It creates an
inefficient SQL Server database that you'd need to substantially
rework if you were at all interested in performance and scalability.

--Mary

>Thanks but I dont see anything in that link that addresses the errors
>I received.
[quoted text clipped - 13 lines]
>>
>> --Mary

Reply to this Message

gaofengmin - 25 Nov 2004 00:47 GMT

> I have access 2000 9.0.6926 sp-3
> I just installed the latest MSDE. I know its working because other
[quoted text clipped - 10 lines]
> question)
> -Wayne

Reply to this Message