Access and the AS400 (2000 -SR1a)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote