Question

I copied a query from a database that was under source code control into the current database which is not under source code control. Every time I conduct a search, SPEED Ferret lists the status of the copied query as Read-Only and will not allow me to make changes to the query. What's going on here?

Answer

When an object is placed under source code control, Access adds an SccStatus property to the object. SPEED Ferret tests the existence of this property to determine whether an object is under source code control. If the property exists, SPEED Ferret checks its value to determine whether the object is checked out to the current user. If not, the object is marked as Read-Only.

When you copy an object from one database to another, the SccStatus property of the object is retained, even if the destination database is not under source code control. If the object was not checked out at the time it was copied, then SPEED Ferret will mark it as Read-Only when you search the destination database.

Does This Problem Affect Me?

This problem affects you only if all of the following conditions are true:

1. Your database is not under source code control.
2. Your database contains objects that were copied from another database that was under source code control.
3. The copied objects were not checked out at the time they were copied.

Solution

Download the latest update to SPEED Ferret for Access 97 from our download page.