Recordset not updateable (from one computer only)

[swisssteve]

I have an Access 2010 database on a Won server 2008 network share which is split into two accdb files - one has the tables (back end) and the other the queries, forms etc (front-end). It has been running for several years.



However on one computer (Win XP Pro SP3 with Access 2010) one particular form hangs on opening, with the message Recordset not updatable. It works on all other ten PC's (with a mix of Win 7 pro or Win XP Pro and Access 2010)

I cannot find any problem and would appreciate ideas. Is there a system or application setting I must adjust on the problem computer?

[ItsMe]

Have you tries placing a new copy of the FE on the XP machine?

[swisssteve]

Have you tried placing a new copy of the FE on the XP machine?

Yes and also tried logging on with my domain credentials in case it was an access privilege problem - but the problem does not go away. The back end is linked directly and not through an ODBC system data source or similar. I looked further and discovered that the two underlying tables (joined in a query) are each taking a long time (30 secs to one minute) to load. One has 2600 records and some fields in these records are linked to small reference tables.

The Performance analyzer does not pick up any problems in these tables and they open quickly on any other computer. So I suspect the problem is something to do with these tables. I tried doubleing the RAM on the System as suggested by Microsoft - no change. The system is perfectly fast for all other uses.

So I am still puzzled.

[ItsMe]

Can you post the code that is requesting the update? Sounds like there is a reference that is not available on the XP machine. I see you have office 2010 installed on the machine. There may be something else missing, something missing on the XP machine that is present on the other machines.

If you have a full version of Access on the XP machine.... you can try and debug it there, on that machine. Make another copy of the FE and import the table(s) that receive the update to avoid issues on the BE. Remove "Option Explicit" from the form's module in the VBA Editor and try to compile. Try and do an update.

Take a look at declarations in the form's class module and any functions it may call.

I can't imagine it is a broken link to a table. The message would read something else.