Navision as linked server in SQL Server 2000

Faberman
Faberman Member Posts: 24
edited 2006-02-20 in NAV/Navision Classic Client
I am attempting to construct a database app. using MS Access 2000 (adp) and SQL server.
I would like to access our native Navision database to execute queries upon it i.e. when running reports or retrieving data on a 'read' basis and displaying it on a form.

I have set up a linked server in SQL and called it NAVISION.
I found an example of a stored procedure which accesses the Nav linked server (using ODBC), but when I run it in Access, I get a message saying that the procedure ran successfully but didn't return any records.
:(

Can anyone send me an example of either a stored procedure or a view, which can access a linked server (and return records) and that can be used as the data source for a form or report?

Any advice will be welcomed.

Thanks.

Comments

  • roshandilruk
    roshandilruk Member Posts: 51
    U want to access Nav DB from Ms Access , is that the thing you want ? make it clear
  • fl
    fl Member Posts: 184
    Hi,

    If you only want to read the SQL database (Navision application) you don't need any linked server. Just create an access project. When you open access you can choose to create a new or open an existing database. But you can also choose to create a project (is an access frontend tied to an SQL server). Just choose there the project with existing data and make a connection to the sql-server (name, database name, user name and password must be known). After that you will get a accees project in which you can find back all your tables. here you can add reports (will be stored in the project file and not in the SQL database).

    But be aware that changing any data there directly in the table or by a form might corrupt your Navision database. [-X

    It's just that easy. :whistle:


    Regards

    Francois Loyens
    Francois
    Consultant-Developper

    http://www.CreaChain.com

Categories