Problem with non-updatable recordset

R

Ragnar Midtskogen

Hello,

I have inherited an Access 2000 application where there is a strange
problem.
The application is a multi-user one with the data in a back-end access from
client applications by way of linked tables.
The app was written on Access 95, ported to 97 and 2000.
The client is running Windows XP Home edition and has Officee XP installed.
Their network is a wireless 54 Mbps.

Recently there was some corruption in a couple of tables, which I fixed, but
now one of the forms, based on a join of two of those tables shows records
which can not be updated.
Today I did a thorough cleaning up of the tables by using recordsets and
skipping any bad records, and now the problem is solved, as long as I do not
connect over a network.
If I open the client on the server, everything works fine, on other machines
the problem is still there.

Any help on this would be appreciated.

Ragnar
 
Top