Record Source Not Available in Multi-User After One User Exits

[smedvid]

Very very strange one.... I am stumped on this one???

I have an MS Access XP DB front-end with SQL Server back-end residing on Citrix. Users just repored issues where a semi-complex form fails when one user exits the application. So if User A and User B are in the application and User B exits, then User A gets an error message when the form attempts to refresh. Almost like the Linked Tables or Connection object is dropped? The exact error message is The Record Source ~...~ specified on this form does not exist. Ugh!!! Any clues on this one are appreciated!

This application has run error free for the last 3 months! Could it be a Citrix issue, SQL Server issue or MS Security Patch issue? Also, Citrix is launching Access-2003 on the XP DB?

The work-around is to have the fornt-end on desktops, but performance is very very slow.

Thanks in Advance!

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[smedvid]

Solved the issue... coding defect in design. Tables are dynamically linked and unlinked. A check to insure all linked tables was not properly position in the Current Event. wow - not found in almost 2 years of use. 80-20 is correct in terms of testing - only 80% can be tested...

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...