Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Czech republic
    Posts
    1

    Question Unanswered: Can't connect from MS Access 2000 to SQL server 2000

    Since the webhosting company's upgraded its SQL server 7 to SQL server 2000, I'm not able to connect from MS Access 2000 to the server and update a DB with 'Convert to SQL database' tool. All I got was a message window with text 'Overflow'. Then I updated Access with SR pack 1 and SQL 2000 readyreness kit. The only thing what changed was the text on the message window. Now it says '[DBNETLIB] [Connection Open(Connect()).] SQL server doesn't exist or the access was refused' if I use already created ODBC data source. If I create a new ODBC data source, the wizard lets me do all steps, starts transferring and abruptly ends with message that transferred tables were skipped or the transfer was unsuccesful.

    Can anybody help me ?

    Or is there any other tool with which I can update tables on MS SQL server ?

    thanks

    Glowi

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: Can't connect from MS Access 2000 to SQL server 2000

    Q1 Can anybody help me ?
    Q2 Is there any other tool with which I can create and modify tables on MS SQL server ?

    A1 Possibly.
    A2 You may wish to consider using MS Sql Server Enterprise Manager, EM, or Query Analyzer, QA, a.k.a.(ISQLW), to aid you in assessing where (and possibly how) the procedures you were attempting to complete have failed (and / or to complete or redo the process, to complete your desired task(s)). It may be easier to import the structures, etc., from EM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •