ACC: Locks Go Away on Forms Based on MS FoxPro v. 2.6 Table
ID: Q154905
|
The information in this article applies to:
-
Microsoft Access versions 2.0, 7.0
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
The record locks for a form based on a linked Microsoft FoxPro table are
released after a period of time. When this happens, multiple users can
update the same record even though the RecordLocks property of the form is
set to Edited Record.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 2.0 and
7.0. This problem no longer occurs in Microsoft Access 97.
MORE INFORMATION
This behavior does not occur at the table level or if the form is open in
Datasheet view.
Steps to Reproduce Problem
In Microsoft Access 7.0
- Open the sample database Northwind.mdb. Do not open it Exclusive.
- Select the Customers table.
- On the File menu, click Save As/Export.
- Click to select "To an external File or Database," and then click OK.
- In the Save Table dialog box, select Microsoft FoxPro 2.6 from the Save
As Type list, and then click Export.
- On the File menu, point to Get External Data, and then click Link
Tables.
- In the Link dialog box, select Microsoft FoxPro from the Files Of Type
list. Select Customer.dbf, and then click Link.
- In the Select Index Files dialog box, click Cancel. Click OK when you
receive a message that the table is attached, and then click Close in
the Link dialog box.
- Select the attached FoxPro table Customer1. On the Insert menu, click
AutoForm to create a new form based on that table.
- Open the form in Design view. On the View menu, click Properties.
- Change the form's RecordLocks property to Edited Record. Save the form
and close it.
- Open the form in Form view and type a letter in the first field.
- Start another instance of Microsoft Access 7.0 and open Northwind.mdb.
- Open the form you created in step 9 and try to type a letter in the
first field. Notice the lock symbol that appears in the record
selector.
- Leave both forms open for about 5 minutes. At some point the record
lock symbol will disappear from the second form, and you will be able
to edit the same record on both forms.
In Microsoft Access 2.0
- Open the sample database NWIND.MDB. Do not open it Exclusive.
- Select the Customers table.
- On the File menu, click Export.
- Select FoxPro 2.6 in the Export dialog box, and then click OK.
- Select Customers in the Select Microsoft Access Object dialog box, and
then click OK.
- Note the file name and directory in the Export To File dialog box, and
then click OK.
- On the File menu, click Attach Table.
- Select FoxPro 2.6 in the Attach dialog box, and then click OK.
- In the Select File dialog box, select the Customer.dbf file, and then
click Attach.
- In the Select Index Files dialog box, click Close. Click OK when you
get a message that the table is attached, and then click Close in the
Select File dialog box.
- Use the Form Wizard to create an AutoForm based on the attached
Customer table.
- Open the form in Design view. On the View menu, click Properties.
- Change the form's RecordLocks property to Edited Record. Save the form
and close it.
- Open the form in Form view and type a letter in the first field.
- Start another instance of Microsoft Access 2.0 and open NWIND.MDB.
- Open the form you created in step 11 and try to type a letter in the
first field. Notice the lock symbol that appears in the record
selector.
- Leave both forms open for about 5 minutes. At some point try to type a
letter in the first field again. The record lock symbol will disappear
from the second form, and you will be able to edit the same record on
both forms.
REFERENCES
For more information about record locking, search for "record locking,"
and then "Editing data in a multi-user environment," using the Microsoft
Access 7.0 Help Index.
Additional query words:
lock FoxPro
Keywords : kbinterop IsmXbase
Version : 2.0 7.0
Platform : WINDOWS
Issue type : kbbug
Last Reviewed: April 30, 1999