dbTalk Databases Forums  

Suddenly no tables could be opened ...

comp.databases.paradox comp.databases.paradox


Discuss Suddenly no tables could be opened ... in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Nils Gustaf Lindgren
 
Posts: n/a

Default Re: Suddenly no tables could be opened ... - 09-25-2008 , 10:35 AM






Thanks both of you.
Apparently a crashed index in one of the main files had caused a shut down
on one of the machines, leaving a "live" .lck file. Unfortunately I had to
re-start the server to be able to eradicate it. Hasn't happened for a long
time, now. Wonder how long I can keep this system running ... the oldest
parts are from 1994 ... too late now to shift to something else ...
Fortunately it remains stable, almost all of the time. In a way, it is to
the greater glory of those who developed the original software lo these many
moons ago.
Cheers
Nils
"Dennis Santoro" <RDAPres (AT) NoRDASpamWorldWide (DOT) com> skrev i meddelandet
news:48dba47f$1 (AT) pnews (DOT) thedbcommunity.com...
Quote:
Assuming the data is on the server as it should be (not the workstations)
then get the workstations out. Look for and delete any .lck and .net files
in the data space and on the users working directories and priv
directories.

Tutility or chimney sweep the files to fix any damage.

Check the idapi.cfg file to make sure it is intact and then make sure all
users are pointed to the same .cfg file or copies that are exactly the
same.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits
since 1982

Nils Gustaf Lindgren wrote:
.... or rather, during the morning the small database distributed over
two work stations from a server malfunctioned more and more.
After claiming that indices were out of date, tables can no longer be
opened and I get the error message
"You have attempted to open a database that is in use by someone else,
but the database cannot be shared. You must set the location for the .NET
control file"
Here is the setup: two workstations with XP Pro, connected through wire
to a SBS Server. No connection to the Internet, and no update nor newly
installed software. The server is not connected to Internet either, nor
has it been updated for several months.
The net drectory is the shared root on the server as it has been for more
than a decade (OK we have changed servers).
We run Pdx 9.
I have never previously had any questions concerning "the .NET control
file".
Where do I start looking?

Cheers

Nils



Reply With Quote
  #22  
Old   
Nils Gustaf Lindgren
 
Posts: n/a

Default Re: Suddenly no tables could be opened ... - 09-25-2008 , 10:35 AM






Thanks both of you.
Apparently a crashed index in one of the main files had caused a shut down
on one of the machines, leaving a "live" .lck file. Unfortunately I had to
re-start the server to be able to eradicate it. Hasn't happened for a long
time, now. Wonder how long I can keep this system running ... the oldest
parts are from 1994 ... too late now to shift to something else ...
Fortunately it remains stable, almost all of the time. In a way, it is to
the greater glory of those who developed the original software lo these many
moons ago.
Cheers
Nils
"Dennis Santoro" <RDAPres (AT) NoRDASpamWorldWide (DOT) com> skrev i meddelandet
news:48dba47f$1 (AT) pnews (DOT) thedbcommunity.com...
Quote:
Assuming the data is on the server as it should be (not the workstations)
then get the workstations out. Look for and delete any .lck and .net files
in the data space and on the users working directories and priv
directories.

Tutility or chimney sweep the files to fix any damage.

Check the idapi.cfg file to make sure it is intact and then make sure all
users are pointed to the same .cfg file or copies that are exactly the
same.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits
since 1982

Nils Gustaf Lindgren wrote:
.... or rather, during the morning the small database distributed over
two work stations from a server malfunctioned more and more.
After claiming that indices were out of date, tables can no longer be
opened and I get the error message
"You have attempted to open a database that is in use by someone else,
but the database cannot be shared. You must set the location for the .NET
control file"
Here is the setup: two workstations with XP Pro, connected through wire
to a SBS Server. No connection to the Internet, and no update nor newly
installed software. The server is not connected to Internet either, nor
has it been updated for several months.
The net drectory is the shared root on the server as it has been for more
than a decade (OK we have changed servers).
We run Pdx 9.
I have never previously had any questions concerning "the .NET control
file".
Where do I start looking?

Cheers

Nils



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.