[AccessD] Novell and Access

Martin,

Linking to a 97 database is going to cause a slowdown, regardless of the
network it's running on.  I believe unicode is the culprit, but I don't
recall details.  I just know from experience that I do NOT link 2000 or
2002 databases to 97 except with a gun at my head!

Charlotte Foust

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Sunday, May 02, 2004 12:18 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Novell and Access


Gustav

Main database is Access 2000. On start up it links into multiple Access
97 databases!. WIll try that out and see how it goes.

Martin


----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Sunday, May 02, 2004 8:53 AM
Subject: Re: [AccessD] Novell and Access


> Hi Martin
>
> > I have a large Access db running on a Novell network. It is very 
> > slow. Sometime ago there was a lot of discussion on setting in 
> > Novell whcih
would
> > improve the perormance of Access on Novell. Anyone remember the
parameters
> > which could be set. I think Seth came up with a solution.
>
> Sadly, I don't think we ever heard from Seth what he came up with ...
>
> So, first, ask your NetWare admin to check these settings:
>
> SET MAXIMUM RECORD LOCKS = 200000
> SET MAXIMUM RECORD LOCKS PER CONNECTION = 100000
>
> For newer NetWare version (>=5?) they should be default.
> If not, they can simply be typed in (as shown) at the console as they 
> are dynamic. If it works they should be inserted in the autoexec.ncf 
> file.
>
> Second, check that your Novell clients are up to date.
>
> Also, look up the thread
>
>   Excel 2000 to Access 2000 link slow on Novell network
>
> from July 2002. It may not represent your situation but has some 
> hints.
>
> If you are running Access 97 data (Jet 3.5) on Access 2000 that may be

> an issue of its own.
>
> /gustav
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com