Error - Cannot open database table

Robert_Hunter_(Guest) · Post by **Robert_Hunter_(Guest)** » Fri Sep 03, 2004 2:05 pm

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__

Robert_Hunter_(Guest) · Post by **Robert_Hunter_(Guest)** » Fri Sep 03, 2004 2:47 pm

We are running Foxpro 6.0 sp5

kfleming · Post by **kfleming** » Sun Sep 05, 2004 8:30 am

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

Robert_Hunter_(Guest) · Post by **Robert_Hunter_(Guest)** » Tue Sep 07, 2004 1:11 pm

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

kfleming · Post by **kfleming** » Wed Sep 08, 2004 6:26 am

Glad to be of assistance.____Kathleen__R&R Support

Liveware Publishing Support Forum

Error - Cannot open database table

Error - Cannot open database table

=> Error - Cannot open database table

==> Error - Cannot open database table

===> Error - Cannot open database table

====> Error - Cannot open database table