Windows XP MS Acess Error

R

royjohnonline

Joined
Dec 15, 2009
Messages
1
Reaction score
0
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
 
royjohnonline said:
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
Click to expand...
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
 
Back
Top