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
  #1  
Old   
Nils Gustaf Lindgren
 
Posts: n/a

Default Suddenly no tables could be opened ... - 09-25-2008 , 07:51 AM






.... 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
  #2  
Old   
Jim Moseley
 
Posts: n/a

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







Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #3  
Old   
Jim Moseley
 
Posts: n/a

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




Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #4  
Old   
Jim Moseley
 
Posts: n/a

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




Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #5  
Old   
Jim Moseley
 
Posts: n/a

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




Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #6  
Old   
Jim Moseley
 
Posts: n/a

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




Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #7  
Old   
Jim Moseley
 
Posts: n/a

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




Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #8  
Old   
Jim Moseley
 
Posts: n/a

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




Nils,

Reboot both computers & run the Clear Lock Files utility on both. That will
probably solve your issues. Search for REMLOK32.exe. I found it here:

http://www.diamondsg.com/paradox.htm#Remlok32

HTH,
Jim Moseley


Reply With Quote
  #9  
Old   
Dennis Santoro
 
Posts: n/a

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



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:
Quote:
.... 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
  #10  
Old   
Dennis Santoro
 
Posts: n/a

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



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:
Quote:
.... 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.