Windows XP MS Acess Error

[royjohnonline]

When I try to open a shared Access2003 database from another computer.

When I try to edit the data the following message appears.

"this recordset is not updatable"

Please help

 

[clydeartwork]

When I try to open a shared Access2003 database from another computer.

When I try to edit the data the following message appears.

"this recordset is not updatable"

Please help

loadTOCNode(2, 'resolution');

1. Start Microsoft Access.
2. Open the database.
3. Select the table that you cannot update.
4. On the Edit menu, click Delete.
5. On the File menu, point to Get External Data, and then click Link Tables.
6. In the Link dialog box, under Files of type, click ODBC Databases().
7. In the Select Data Source dialog box, select the correct data source, and then click OK.
8. In the Link Tables dialog box, select the table that you deleted in step 4, and then click OK.
9. In the Select Unique Record Identifier dialog box, select a field as the unique index, and then click OK.

You can now update and add new records to the table.
I once had the same kind of problem, i tried this method and it worked. Good luck, i hope it will work out for you