Results 1 to 2 of 2

Thread: Access Report

  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Question Unanswered: Access Report

    Hi,
    I developed a report in Ms-Access which is a linked database to Sql Server. on my server every thing is running good, i deployed in the other directory and people started testing it is not working..what could be the reason i appreciate your help..
    Thanks
    Vamsy

  2. #2
    Join Date
    Dec 2003
    Location
    Dublin,Ireland
    Posts
    13
    In what way is it not working????


    if the report appears but is a blank page, then heres a few SQL thingys to look out for, they may be the source of your problem.


    have you given everyone else full permission to use the reports data sources???

    make sure they have the appropriate permission to use any new stored procedures or views you created for the report to use as its method of retrieving information from the tables....

    make sure they have access rights to the tables too! check the access connection and ensure its connected to the right server and database.

Posting Permissions

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