S
Subir Kumar
Hi,
I am having problems with migration from Access to SQL
server and would like some guidance from anyone.I have
tested the set of instructions in another post to confirm
that the SQL server is working fine. I am using SQL Server
Version 5 SP3 and Access 2000. The problems I am having are
1. If I try to use upsize wizard and click on create a new
database, I am getting two errors
a. This Operation cannot be done by connecting asynch.
[Also my SQL server name does not appear in the list of
SQL Servers].
b. The upsizing wizard only works with Microsoft SQL
Server (Versions 6.50 SP5 or higher).
2. If I create a database in my SQL Server and then try
and upsize using the "existing database" option, I am able
to successfully migrate [Creating a new Machin data
Source, also the server name shows in the drop down list
of servers this time].But the problem is that when I close
the ADP created and then reopen it,it doesnt show any link
tables etc,shows only the forms and reports and in the
taskbar it shows error [databasename:disconnected]
if possible please guide me in this matter. Thanks in
advance.
Regards,
Subir Kumar
I am having problems with migration from Access to SQL
server and would like some guidance from anyone.I have
tested the set of instructions in another post to confirm
that the SQL server is working fine. I am using SQL Server
Version 5 SP3 and Access 2000. The problems I am having are
1. If I try to use upsize wizard and click on create a new
database, I am getting two errors
a. This Operation cannot be done by connecting asynch.
[Also my SQL server name does not appear in the list of
SQL Servers].
b. The upsizing wizard only works with Microsoft SQL
Server (Versions 6.50 SP5 or higher).
2. If I create a database in my SQL Server and then try
and upsize using the "existing database" option, I am able
to successfully migrate [Creating a new Machin data
Source, also the server name shows in the drop down list
of servers this time].But the problem is that when I close
the ADP created and then reopen it,it doesnt show any link
tables etc,shows only the forms and reports and in the
taskbar it shows error [databasename:disconnected]
if possible please guide me in this matter. Thanks in
advance.
Regards,
Subir Kumar