alcsy8 alcsy8

Niner since 2010


  • The Access Show: Access 2010 demo of Access Services and web databases

    Hi ClintC,


    AccessHosting folks finally gave me an account. I published a test database into it after running the compatibility check with no issues.


    In the web it does not work and I kept getting the message below.


    Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane.
    An error occurred during local report processing.
    An attempt was made to set a report parameter 'SMID' that is not defined in this report.


    I totally do not understand the message and appreciate if you or others can provide some in sight to overcome it.


    The flow is as below.


    1. When the program launch, a form is displayed by Salesman.
    2. When you click the View Report button a report should open and be filtered to the selected SMID.

    The macro behind the button as below.


    <?xml version="1.0" encoding="UTF-16" standalone="no"?>
    <UserInterfaceMacros xmlns=""><UserInterfaceMacro For="Command30" Event="OnClick"><Statements><Action Name="OpenReport"><Argument Name="ReportName">Sales History</Argument><Parameters><Parameter Name="SMID" Value="[Forms]![WT_Salesman]![SmID]"/></Parameters></Action></Statements></UserInterfaceMacro></UserInterfaceMacros>


    I also understand that web query cannot do grouping or summing. What is the alternative?





  • The Access Show: Access 2010 demo of Access Services and web databases

    Hi ClintC


    Thanks for this spontaneous reply.


    For items 1 & 7, I look forward to the addresses.


    For items 5, the capacity of 500K rows in a table seems like a limiting factor to adopt this exciting web feature. Some trading houses I worked with have normalized data of approximately 1 million rows (4 years records). Many use 1+3 years sales data to forecast future performance. A query is only as good as what is in the table we are quering into. How to overcome this?



    Thanks for the answers.

  • The Access Show: Access 2010 demo of Access Services and web databases

    Web Database

    I downloaded Access 2010 beta. I am particularly interested in its Web capabilities and appreciate any guidance and answers to my questions below.

    I tried getting free hosting at this site without success and thus was not able to test its new functionality.

    My sincere apologies, if some of the questions are intimidating or seeking answers that are obvious.

    1. Can I publish to Access Services an accde format (I do not want any design changes by other users)?  When any users login or run their FE when connected to the web will they get all new design changes for both web and client objects while online? Most of the text I gathered from the net does not specifically address accde online update.
    2. Access 2010 has both Web objects and Client objects (Form, Report, Query etc.).  If I am not interested to run in browser, should I just create with Client objects and still get all the benefits of the web link (multiuser like environment).  The reason why I want to create with Client Objects is because I can use VBA + Macros.
    3. Are there number of users’ limitation? How many users can run their FE (accde) simultaneously to enter new data or retrieving it online?
    4. Are there any rows (in table) limitation, 1 million, 10 million or more rows of records.
    5. When I create a new Web database and decided not to Publish it to Access Services, can I still create the conventional split to FE/BE and expect it to function normally (even if I had created all my objects with Web objects)?
    6. Is it difficult to create user level security in Sharepoint 2010/Access Services. The usual expectation is to limit a subset of data only to certain users. If I am not wrong, Access 2010 will cache all data into the local table once a user gets online and all is dangerous.
    7. Can multiple column primary keys be set? I use this in a number of my tables to prevent duplicate records.
    8. In my database, it is not uncommon to run bulk delete and append queries to a data table. Can an administrator still perform this function in web solutions?

    Thanks (