D
Dave
I have copies of an Access2K app that run in two locations using
tables from the same backend database (Oracle). The app includes
several append queries, all but one of which behave normally (the
target table is in the local application mdb). However, there is one
query that works correctly at my location, but fails at the other
location. At both locations the query returns the same records in
datasheet view or when run as a select query, but in append mode it
appends the returned records only at my location - at the other
location it appends nothing and displays the message "...about to
append 0 records...".
Does anybody have any suggestions?
Thanks
Dave
tables from the same backend database (Oracle). The app includes
several append queries, all but one of which behave normally (the
target table is in the local application mdb). However, there is one
query that works correctly at my location, but fails at the other
location. At both locations the query returns the same records in
datasheet view or when run as a select query, but in append mode it
appends the returned records only at my location - at the other
location it appends nothing and displays the message "...about to
append 0 records...".
Does anybody have any suggestions?
Thanks
Dave