Jet database and novell netware 3.12
Also, make sure your Novell setting for Max record locks per user is
set to the max 10,000. Without this, batch (multi-record) updates are
limited to a very, very small number.
Quote:
>> Hello,
>> I'm working on a project with VB4(16bit) and a Access 2.0 database. The
>> Access database is secured by a SystemDB. As long as I run the app locally
>> everything works, but the thing is suposed to run on a Netware 3.12 Server
>> in a multiuser enviroment. If I try it on the Server it works for a while,
>> but then I get an error 3000 which has a message with it, that the
>> undocumented error -1106 occured. Afterwards I can't update about 40
>> records. It appears exspecially when I do wide jumps in the database (13000
>> records). If I open the database exclusive it works. I know it has to do
>> locking pages.
>> Does anybody have a clue about this and can tell me how to solve the
>> problem?
>> Please write to my Email address.
>> Thanks in advance
>> --
>> regards,
>> Uwe Weiss
>After you do an update use freelocks for vb3 and dbengine [freelocks]
>for vb4.
