This is a question relating to Access 2000/2002, which the Province of Ontario is still using. I have a query based on a join between an ODBC linked SQL Server table and an Access table. The query-based form, running in datasheet mode only, displays the linked columns as "locked" for informational and sort purposes and allows edits on the columns representing items from the local database. It is a data entry form with no totals or calculations and only allows update.
All works well except for one issue. When a column from
one of the linked items is selcted (clicking on the column label), the form's cursor changes to either a down arrow or a cross, that status bar displays the word "calculating... " and the form gets stuck on the column for a minute or more. I assume it is re-querying the linked table. Is there something I can set that will prevent this from happening?
All works well except for one issue. When a column from
one of the linked items is selcted (clicking on the column label), the form's cursor changes to either a down arrow or a cross, that status bar displays the word "calculating... " and the form gets stuck on the column for a minute or more. I assume it is re-querying the linked table. Is there something I can set that will prevent this from happening?
Comment