upsizing wizard access 2000 MSDE

[Wayne Harper]

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

 

[Mary Chipman]

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

 

[Wayne Harper]

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

 

[Mary Chipman]

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

 

[gaofengmin]

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