I am using MS Access 2000 on an Windows XP machine and am trying to
use
the Upsizing Tool in Access 2000 to upsize an Access 2000 database to
use with Microsoft SQL Server 7.0.
My MS Access 2000 version is part of an Office 2000 Developer Edition
upgrade from Office 97. Included in the Office 2000 SR-1 Developer
package is a disk entitled Microsoft SQL Server 7.0 that I have
installed.
When I try to upsize a database using the Access 2000 tool a dialog
box comes up including the question "What Server would you like to use
for this database?" In this box "Microsoft SQL Server 7.0" is aleady
there. When I click OK the following error message comes up:
Connection failed:
SQLState '01000'
SQL Server Error: 1231
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
Can anyone please enlighten me and provide some possible solutions.
Cheers
Michael