Page 1 of 1
Cannot open Database Table <Advantage Database Server>
Posted: Thu Jun 21, 2001 12:00 pm
by Paul_Hooper_(Guest)
I am getting the error message "Cannot open Database table [ Table may be in use]" when trying to use my main live databases,I presume it is a file locking problem - I am using Advantage Database Server on a Novell Network [R&R v9] has anyone any ideas as this results in me having to use non live archive Data.
=> RE: Cannot open Database Table <Advantage Database Server>
Posted: Fri Jun 22, 2001 4:48 am
by kfleming
From the R&R side, make sure that the Allow users to update tables in use by R&R checkbox is enabled in Options->Default Settings.____Kathleen__R&R Support
=> RE: Cannot open Database Table <Advantage Database Server>
Posted: Fri Jun 22, 2001 7:06 am
by Bob_Powell_(Guest)
Yes, thanks Kathleen I have done that - no good. Having done some further investigation the problem is confined to just one machine on our network, all the others report fine off the live data but mine won^t. Reports start to run o.k. but seem to slow and pause then crash part way through as though it^s a problem with buffers or memory or something. Having done that I can^t then re-access the report library etc. until I log out of Novell and back in again. I have reinstalled the R&R software also the Novell drivers etc. any Ideas?
==> RE: Cannot open Database Table <Advantage Database Server>
Posted: Fri Jun 22, 2001 9:24 am
by Paul_Hooper_(Guest)
We are having that problem when a particular report is run to print envelopes... the R&R report runs but it definitely is locking the dbf file in such a way that no other user can open the file. I have check the users R&R default settings and they have "Allow other users to access tables ... " checked. The machine that is running the report is using version 8.1 and has Win2000 installed.