open Access table = locked Access table??
When you open a database in Access there is a check box labelled
"Exclusive". If this is checked, no other application will be able to open
the database. Page level locking only comes into effect if the database is
not exclusively locked. You can also lock an individual table, with
"ShareDenyRead". Page level locking will only come into effect if neither of
these is true.
Graham
Quote:
>-- Under what circumstances are Access tables locked for viewing purposes?
>For example, if I try to print a report in Crystal Reports against a table
>that I also have open in Access 97, I get an error in Crystal telling me
>that the table is exclusively locked. I thought that Access only locks a
2k
>page at a time and that this only happens during an Edit/Update operation.
