Liveware Publishing Support Forum

Error message -- Cannot open database table____We have been running R&R windows runtime (V8.0a) from within Foxpro programs for many years. We have recently upgraded our hardware and are getting some new R&R error messages such as "Cannot open database table (table may be in use): STOR_REC.DBF" where STOR_REC.DBF is a file used in the report and is most likely open within the Foxpro session that called R&R. Nobody has the dbf opened exclusively, and it has never been a problem before. Closing all the files before calling R&R is not a very realistic option.____The old setup used Win98 workstations and the datafiles were on a Novell 3.2 fileserver and the new setup is WinXP workstations and the datafiles are on a Windows2000 server.____I think that upgrading to a later version of R&R is a bigger project than we can handle at the moment because of the R&R library issues, so if anyone has any ideas about how to fix this problem please let us know. ____The Foxpro command that invokes R&R is ____RUN /N &m9dir_rrw.rrwrun &m9dir_dbf.rrunin &rr_recno /o&mrrunout /WY____which translates to something like this if I take out the runtime macros:____RUN /N f: rw rwrun v:direct runin 26 /o&mrrunout /WY ____PS - I^ve tried going back to V6.5 and I get the same error____Thanks, Rob__

We are running Foxpro 6.0 sp5

Do you see the same error if you try to open the report in the report designer? Is your default data directory in RRW.INI set to the directory where the table resides?____Kathleen__R&R Support

Thank you. Thank you. Thank you!!____First of all, thank you for responding on a Sunday - and in the midst of a long weekend too.____Secondly, thanks for solving my problem. I had totally forgotten about rrw.ini, and setting the dbf default directory fixed the problem straight away.____Thirdly - thanks for being a genius. You are very much appreciated.____Rob

Glad to be of assistance.____Kathleen__R&R Support