Hello there,
I am trying to get to the bottom of an 'Object invalid or no longer set' issue, but I am not a database programmer.
We have approx 20 users on MS Access 2002 front ends on 2 sites connected by WAN using a SQL 2000 SP4 database backend.
1 site is 24 hours, the other is 9 - 5 operation.
We have a SQL database at both sites using replication. Every 10 minutes the data entered at 24hr site is uploaded to 9-5 site and then merged.
We get intermittent 'Object invalid or no longer set' message pop up on the 24hr site. However having closely monitored the activity it only occurs when there are users usiong the database on the 9-5 site. After a merge has taken place the 'object invalid' message can pop up on 1 workstation at the 24 hour site.
Both sites are running Windows XP SP2 and MS Office XP Pro SP3 (so MS Access 2002 with SP3)
I have checked that all machines are running the correct version of MSJET40.DLL and they all have the correct version 4.0.8618.0
There are no run-time error numbers or any events in Event viewer on the workstations. There are no network connectivity problems (continuous pings from suspect workstation to db server and back again show no loss at all)
Curiously once the 9-5 site have gone home the error never occurs at he 24hr site.
Also the users that experience this don't actually have to be active in the Access front-end.
My first question is, Would this be an Access or SQL issue?
Any pointers woudl be very helpful.