Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access and the AS400 (2000 -SR1a)

    I am trying to create reports in Access based on AS400 tables. I have the tables linked in correctly and run queries against them. However, whenever I try to create a report I states I have to have the database open in exclusive mode or nothing will be saved. How can I get around this?

    Tom

  2. #2
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Access and the AS400 (2000 -SR1a)

    Hmmm..don't know about AS400. Queries are OK, but reports complain?

    When I had trouble yanking data out of Lotus Notes via ODBC, I used "make table" and "append" queries to make my own data table in Access from the Notes data. Gave the user a button to click to delete and recreate that table as needed. Another button ran the report pointing to my new table.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and the AS400 (2000 -SR1a)

    Forgive me for asking a stupid question, but just to cover all possibilities - nobody else is in the database when you are trying to create the reports, correct?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access and the AS400 (2000 -SR1a)

    There is no workaround if you're trying to create a report. Access 2000 will not let you design or modify code-container objects like reports unless you have the database opened exclusively. It may seem like an inconvenience but it's actually a safeguard that came in with the VBE in Access 2000.
    Charlotte

Posting Permissions

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