ADP conneciton issues, Link tables missing

[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

 

[BJ Freeman]

I educated guess, is when you created the ADP you did not select remember
password.
go to File Connect.
see if you have it set, if not, enter the password and make sure allow blank
password is unchecked and allow saving password is checked..

 

[Gail]

Try applying SR1a and SR2 patches to your Access 2000. I
had a similar problem loosing all the VBA modules as I
progressed with my application.

Gail

-----Original Message-----
I educated guess, is when you created the ADP you did not select remember
password.
go to File Connect.
see if you have it set, if not, enter the password and make sure allow blank
password is unchecked and allow saving password is checked..

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

.