-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Tables Topic   Print This     

"No more files" error

"No more files" error in Paradox Tables topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: "No more   "No more files"  
Allan.P
-- --

Upgraded a win 7 box to win 10. 

Using a win 7 client.  Now recieve the error:

Cannot open: :dbx:table.db

No More files.

Table: table.db

Table: \\earth\database\xxx

Happens both manually and programatically.  Can usually get it to work if I quickly try to access same table/query again.  The longer I wait before retrying the greater the chance it will error again.

I see some similar issues online after Win 10 updates.

Do we have a fix?

 Posted 7 years ago (Thread Starter)
Comment Quote
About Allan.P
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17784, 8 replies
Thread Started 12/31/2019 7:21:52 AM
View Counter=954
Last Reply Posted 1/21/2020 10:34:43 AM)
Location=-- -- 
Joined=10 years ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

over the past year, I've seen a number of weird file-access errors on Win10.. I haven't seen this particular one, but it fits the pattern

no real fix, other than a beboot, and the next win10 update.. scary stuff

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 7 years ago
Comment Quote
About Steven.G
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17785 (Level 2) and Parent is 17784
Reply Posted 12/31/2019 8:12:28 AM
Location=Myrtle Beach, SC USA 
Joined=10 years ago   MB Posts=463  
Allan.P
-- --

Thinking a few options.

  1. Host Paradox DB on a Linux server
  2. Host DB on a dedicated NAS drive
  3. Port DB to MySQL (not even sure MySQL will work with pdox now)

I need to insulate this db against Microsoft updates.

Whatcha think?

 Posted 6 years ago (Thread Starter)
Comment Quote
About Allan.P
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17790 (Level 3) and Parent is 17784
Reply Posted 1/3/2020 10:31:33 AM
Location=-- -- 
Joined=10 years ago   MB Posts=7  
rum
Frankfort, KY USA

Is the database currently hosted on the local win 10 computer?  Or a windows server? (What OS?)

 Posted 6 years ago
Comment Quote
About rum
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17792 (Level 4) and Parent is 17784
Reply Posted 1/3/2020 11:18:01 AM
Location=Frankfort, KY USA 
Joined=9 years ago   MB Posts=128  
Allan.P
-- --

On a win 10 box, just peer to peer.

Clients are win 7/10.

 Posted 6 years ago (Thread Starter)
Comment Quote
About Allan.P
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17793 (Level 1.1)  Reply to 17792 and Parent is 17784
Thread Started 1/3/2020 11:35:01 AM
Location=-- -- 
Joined=10 years ago   MB Posts=7  
rum
Frankfort, KY USA

What version of Paradox?

I had a very similar issue on Ver 8.  (Before Win 10 killed it)  The issue was related to the BDE Version that was running (which is really related to the SMB protocol that is being run under the covers,  so you might look into that on the Win 10 server).   Anyway,   The pre-installed BDE version(contained in the PDOX 8 install) worked forever,  then I started seeing the error pop up. There were some tables that would open,  others that just flat refused.  My issue was usually tied to the installation of a new server (Small Business 212, for one)

After installing BDE 5.2,  the problem went away.

Let me know if you want to try BDE 5.2,   I can probably scrounge up a url for the download.

 Posted 6 years ago
Comment Quote
About rum
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17798 (Level 5) and Parent is 17784
Reply Posted 1/3/2020 8:18:57 PM
Location=Frankfort, KY USA 
Joined=9 years ago   MB Posts=128  
Allan.P
-- --

Pdox 11  BDE 5.2

On the interesting side I did get MySQL working on server and pdox client.  However a conversion to SQL does not excite me.

I am thinking linux box/NAS.

 Posted 6 years ago (Thread Starter)
Comment Quote
About Allan.P
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17801 (Level 1.1)  Reply to 17798 and Parent is 17784
Thread Started 1/4/2020 9:14:20 AM
Location=-- -- 
Joined=10 years ago   MB Posts=7  
Allan.P
-- --

Re: Paradox/BDE No More Files error.

I have tried a workaround with some success.  

Do a loop testing IsTable(tableName) before trying to open the table/query.  

I will post the code later after more testing, but it seems to be working.

 Posted 6 years ago (Thread Starter)
Comment Quote
About Allan.P
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17825 (Level 6) and Parent is 17784
Reply Posted 1/21/2020 10:27:58 AM
Location=-- -- 
Joined=10 years ago   MB Posts=7  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

isTable and isFile force the file buffers to flush, so that makes sense.. and really can help as a warning here, if you're getting "false" returns, when you know you shouldn't be

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 6 years ago
Comment Quote
About Steven.G
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17826 (Level 7) and Parent is 17784
Reply Posted 1/21/2020 10:32:31 AM
Location=Myrtle Beach, SC USA 
Joined=10 years ago   MB Posts=463  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1202A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17784 Counter
954
Since 12/31/2019
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]