Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Frankfurt, Germany
    Posts
    20

    Exclamation Unanswered: canīt open sql database tables from access adp project

    hi there,

    we canīt open most of the sql server tables from our Access
    project any more, which has to be related to collation or
    extended property problems.

    trying to open any table will result in the information
    "The stored procedure has been executed but did not return
    any records" after the first try
    and later on nothing will happen any more; tables wonīt
    open.

    basically this started to happen after recreating the sql
    database due to resolution 1 in Microsoft Knowledge Base
    Article - 318989:
    collation of the server is Latin1_General_CI_AS
    collation of the old database was
    SQL_Latin1_General_CP1_CI_AS, which led to the error
    described in the article.
    collation of the new database is set to <Database
    Standard>, now i have the problems described above.

    anybody some good help on that?

    ps: we canīt really rebuild the user database all the
    time, because we got flight data in about 4 billion
    records in there, so we will need anything quick and
    easy...
    thanks

    ron

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Hello there,

    Firstly do you have the latest Office service packs installed?

    Do you have the latest version of MDAC?

    Have you tried creating a new project and linking that to the SQL database?

  3. #3
    Join Date
    Jul 2003
    Location
    Frankfurt, Germany
    Posts
    20
    i got office xp sp 3 (=latest), mdac 2.8 (=latest), and i tried of course the recreation of a new access project: all failed

    still more ideas...????


    thanx
    ron

Posting Permissions

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