rrwin32 holding onto tables???

[mkozma1]

I have two clients connecting to the same data by the runtime rrwin32. One client can display the report but if I try to get the second client to open the report, I get a table in use error by R&R even though I have closed the report on the first client.__I have tried to close the application on the first client but to no avail.____Anyone had this problem before?

[ColinDow]

We had a similar, but not identical, problem years ago when we used access and the odbc driver setup had been set as exclusive in the advanced settings. Unchecking this and making the driver read only did the trick.____We only had this problem with concurrent users though. If you are using a control table it would be useful to find out if the error was related to your control table or the report table.

[mkozma1]

Thanks for the reply.__I^ll have a look at it again.__I am using the Apollo server which does not use the ODBC.__The control table sits in the same directory as rrwin32 as does the report files. The reports use the data from the data folder.__The error I receive is r&R error relating to the data table that I^m trying to access.__It^s almost as if the server allows the first client to access the data but then when a second comes along to use it, it won^t allow him. Not until I restart the server.____I^ll keep trying.____