Recordset not updatable

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Hello,

I have a form with quite a few tables for viewing data. A few weeks ago I
added table Status to the main Order Entry form and then to this viewing
form. The link on the query is not directly to from the Order Entry form to
the Status table, but there is a totals query of fileds in the Status table
in between connect by an outer join. This totals query is also connected by
two fields in a many to many relationship, but in the query they are unique
values.

SO the connection is. {Order Entry] Left outer join to [Totals Query] Left
outer join to [Status]

A text field from status gets updated in the viewing form This worked fine
when I first installed it. Then porting the app to SQL Server, I had a
problem what the recordset is not updateable. I connected to my clients
machine to find out that that is now not updateable. The Machine I
conencted to with PC Anywhere is running Windows XP. Some of the machines
there are using the screen without a problem and some are not I have found
out today.

So I am puzzled here. Locally on my PC it does not work. I have Access XP
and Windows XP. My client is also running Windows 2000 workstations and it
is possible that those machines are not having an issue, but can't be sure
at this point if that is true.

Are there any issues that any of you know of that could help me?

Thanks and God Bless,

Mark A. Sam
 
Back
Top