Paradox Community

Items in pnews.paradox-programming

Subject:Re: No more files
Date:Tue, 28 Feb 2023 18:21:44 -0700
From:Liz McGuire <liz@paradoxcommunity.com>
Newsgroups:pnews.paradox-programming
I agree with Kevin.  The only thing I would add is to ensure all the networking settings are
correct.  It's been ages since I did Paradox on a network with multiple users...

LOCAL SHARE has to be TRUE.  Oplocks (Opportunistic locking) have to be disabled.  Disk caching
should be disabled.

Oh, and I wonder if the BDE's 4GB error could be causing this.  I never had to deal with this
so again, I don't remember the details.  I *think* it's a problem when there's an exact multiple
of 4GB of disk space free.  (Or was it 2GB?)  The newsgroups should have lots of discussion
on this issue.

Finally, perhaps one of the BDE file limits?  MAXFILEHANDLES might need to increase?  (I have
a doc from Mike Irwin recommending 150.  I'd probably set it to the max - 255.)

FWIW, here are the BDE settings I always use:

Configuration > System > INIT

RAM AMT. (MB)    256+      128
==============================
LOCAL SHARE      TRUE     TRUE  *******VITAL
MAXBUFSIZE =    65536    32768
MEMSIZE    =      180       84
MINBUFSIZE =     4096     4096
SHAREDMEMSIZE = 61440    28672


Configuration > Drivers > Native > PARADOX

BLOCK SIZE = 16384 (drop-down list)
LEVEL = 7
STRICTINTEGRITY = TRUE


Configuration > System > Formats > Date
All which are True/False should be TRUE
MODE = 0
SEPARATOR = /

Liz


On 25 Feb 2023 17:43, Linda wrote:
> Thanks for quick answer.
> 1) The error message "No more files" appears when I open a normal table (.db
> ) file or when I open a form (.fsl) which has a table in the data model.
> It never happens if i do an immediate new try and just 1 of 10 times. The
> error box gives no more information. Perhaps it disappear again after som
> time.
> 
> 2) The opened table (.db) suddenly closes when I click on a field or try
> to scroll and sometimes witout touching it. It happens just  after some minutes.
> All files are on a file server winServer 2019. I am not sure if the same
> happens with local files. I will try it out first.
> 
> 


Copyright © 2004 thedbcommunity.com