Basic connection to an ADP database - problems and more problems

[Chris Strug]

Hi,

I'm trying to develop a few test Access 2000 ADP applications.

I have a copy of SQL Server 2000 running centrally. I am trying to develop
an ADP application and I'm having problems all over the place.

The main one is when I create a new Project (New Database) and name it. The
MS SQL Server Database Wizard appears. I select my server and the name of
the database. I enter the ID and password of the server administrator. On
clicking next I get a msgbox saying "Overflow". This happens no matter what
ID and pwd I enter.

What on earth is happening? Is this a permissions issue or is something
broken?

Any advice is gratefully received.

Thanks

Chris Strug

 

[Chris Strug]

Hi,

FWIW, after some digging I found this KB article that resolved the
problem...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q272/3/84.asp&NoWebContent=1

Cheers

CS