upsizing wizard access 2000 MSDE

  • Thread starter Thread starter Wayne Harper
  • Start date Start date
W

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
 
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 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
 
Wayne Harper said:
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
Click to expand...
 
Back
Top