Jet 3.0 Multi-user stability

Jet 3.0 Multi-user stability

Post by Lambert Wolterbeek Mulle » Fri, 13 Sep 1996 04:00:00



Hi,

We are considering to use the Jet 3.0 format in our applications, but we
would like them to be multi-user applications. The number of users would be
less than 10. In the past we have had a lot of corrupted database problems
with Jet 2.x applications that were used by up to 5 or 6 users
concurrently.

Does anyone know if Jet 3.0 has been improved in this respect? In other
words is it more robust in multi-user situations than Jet 2.x? Any pointers
to more information or documentation would be greatly appreciated.

Thanks in advance,

Lambert Wolterbeek Muller,
Davilex Software.

PS. We are aware of the fact that a client/server solution would solve this
problem, but that is not an option at the moment.

 
 
 

Jet 3.0 Multi-user stability

Post by Edward Menefe » Sat, 14 Sep 1996 04:00:00


Check your hardware, upgrade if necessary. What network are you on; set
file server locks to the maximum since this can be a problem with large
Access queries.
Corruption problems in MS Jet usually occur when PC's experience hardware
problems, or connections to an open database are broken. My agency has
several Access 2.0 databases shared on a Novell Netware 3.12 server, with
users across the state of Texas dialing in via PCanywhere and running
remote sessions, both on a 56kb data circuit, and over standard telephone
lines with 2400 baud modems.
We have one large database that 50 users constantly access, and it has
experienced corruption problems (somtimes 5 times a month, but can go for 6
months without a problem).
Corruption occurs: 1) when dial-in users experience telephone line
difficulty and the connection is broken; 2) when a user's PC hard drive or
memory fails, at which point they end up re-booting. We almost never have
problems on the local area network connections.
Before repair and compact, delete the "LDB" (locking database file) first
since it keeps track of locked records which the software may think are the
only records.
And yes, we are making the transition to client server using MS NT/SQL and
Access 7.0 on an Digital Alpha box.



Quote:> Hi,

> We are considering to use the Jet 3.0 format in our applications, but we
> would like them to be multi-user applications. The number of users would
be
> less than 10. In the past we have had a lot of corrupted database
problems
> with Jet 2.x applications that were used by up to 5 or 6 users
> concurrently.

> Does anyone know if Jet 3.0 has been improved in this respect? In other
> words is it more robust in multi-user situations than Jet 2.x? Any
pointers
> to more information or documentation would be greatly appreciated.

> Thanks in advance,

> Lambert Wolterbeek Muller,
> Davilex Software.

> PS. We are aware of the fact that a client/server solution would solve
this
> problem, but that is not an option at the moment.


 
 
 

1. VB 3.0 Pro/Jet 2.0 and heavy multiuser environment

Hello,

Does somebody have experience about using application made in VB 3.0 Pro
that uses Jet Engine 2.0 (or perhaps 2.5) in multiuser environment where
is large amount of users and 'quite' a lot of data? Tell us something
about the mess!

Tom Niemi
EDI Management Finland Ltd.

2. CA-SAN FRANCISCO-93161--ORACLE Financials-ORACLE-Oracle Financials Consultant

3. ADO With Jet Provider, Multi User Hell, Please help

4. Linked Server Permissions

5. JET Multi-user problem

6. update speed

7. Jet in Small Multi-User LAN

8. SQL Server import from FM

9. Jet Engine Multi-User features

10. Multi-user Access97 (jet 3.5) database on a Novell system

11. Multi User VB 6.0, ADO, Jet

12. Multi-User Client Server (Urgent) Jet?

13. Multi User database using MS Jet 4 and ADO