VB3/Novell/Access 2.0 -- Safe or not? 
Author Message
 VB3/Novell/Access 2.0 -- Safe or not?

Am considering using VB3 (after all the reports of bloated code, slowness
and trouble with VB4 16-bit) for a large project on a Novell network and
WFW 3.11, using Access 2.0 data files and the "compatibility layer."
Customer insists that this be 16-bit, so 32-bit VB4 isn't an option.

There have been postings here re. VB4 not being able to save projects on
Novell networks.  Can VB3 projects save OK on Novell networks?

Other postings talk about problems with data integrity with Access.  Is
Access the problem or just using Access 2.0 data files w/ VB3 & the
compat. layer?  Does critical data really get lunched regularly or is this
the isolated experience of a few users?

Would like to use config. above for a critical project for a large client,
but would appreciate reports (good and bad) from anyone who has already
attempted to do this.  You can either reassure me or save me a lot of
trouble.  Thanks.

Steve Young
Young Computing



Wed, 20 May 1998 03:00:00 GMT  
 VB3/Novell/Access 2.0 -- Safe or not?

Quote:

>Am considering using VB3 (after all the reports of bloated code, slowness
>and trouble with VB4 16-bit) for a large project on a Novell network and
>WFW 3.11, using Access 2.0 data files and the "compatibility layer."
>Customer insists that this be 16-bit, so 32-bit VB4 isn't an option.

>There have been postings here re. VB4 not being able to save projects on
>Novell networks.  Can VB3 projects save OK on Novell networks?

>Other postings talk about problems with data integrity with Access.  Is
>Access the problem or just using Access 2.0 data files w/ VB3 & the
>compat. layer?  Does critical data really get lunched regularly or is this
>the isolated experience of a few users?

>Would like to use config. above for a critical project for a large client,
>but would appreciate reports (good and bad) from anyone who has already
>attempted to do this.  You can either reassure me or save me a lot of
>trouble.  Thanks.

>Steve Young
>Young Computing


I've never had a problem saving VB3 projects onto a mapped drive on a
Novell network.  I run VB3 at work under WIN/OS2, so if it works there
I am sure it will work under 'real' Windows!

I don't have that much experience with Access databases and VB3, but
am working on a project using a setup similar to which you are looking
at.  For a large number of users I would think that you would want to
look for a better database and get to it through ODBC from VB3.
Access can't lock single records on the database, it lock a page at a
time (4K I believe), so if there are a large number of updates being
done I would think you could run into real problems, although probably
only performance waiting around for the record to be freed up, them
maybe worrying about overwriting someone elses changes.

But, like I said, I am no expert.  Hopefully some Access and VB gurus
will give you (and me!) more information.

Hope this helps some,

Mark

Web page: http://www.novia.net/~markh



Thu, 21 May 1998 03:00:00 GMT  
 VB3/Novell/Access 2.0 -- Safe or not?

Quote:

>> Novell networks.  Can VB3 projects save OK on Novell networks?
>> Other postings talk about problems with data integrity with Access.  Is

VB3 works fine with Novell networks.

I have used VB3 with Access 2.0 databases for a long time with very few
problems -- the rate of database corruption in Access files was
significantly lower than the rate on similar networks performing similar
tasks with different database formats. The databases were used
concurrently by up to 20 people at a time for extended periods and ranged
in size from 15MB to a 550MB monster file (transaction city).
Unfortunately, there was noticable performance problems as the file size
grew. It wasn't BAD, but it was visible...

--j.



Thu, 21 May 1998 03:00:00 GMT  
 VB3/Novell/Access 2.0 -- Safe or not?
Quote:
>There have been postings here re. VB4 not being able to save projects on
>Novell networks.  Can VB3 projects save OK on Novell networks?

Yes they can.. I've been doing that for a while.

Quote:
>Other postings talk about problems with data integrity with Access.  Is
>Access the problem or just using Access 2.0 data files w/ VB3 & the
>compat. layer?  Does critical data really get lunched regularly or is this
>the isolated experience of a few users?

I have quite a large application which uses Access 2.0 compat. layer,
and the ONLY time i had problems was when i called older dated .DLL's
(ie older Novell NETWARE.DLL etc.) which were buggy which caused
Windows to hang and corrupt the database.


Mon, 25 May 1998 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

2. Major Help needed with VB4 + Windows 3.11 Linked to Access 2.0 on Novell 4

3. Access 2.0 NT/Novell Incompatability?

4. Help: Problem reading Access 2.0 mdb from VB3 under Win95/Access 7.0

5. Problems accessing Access 2.0 via ODBC 2.x from VB3.0

6. installing source safe on Novell 3.11

7. Code from Access 2.0 not working in Access 2000

8. VB3 to Access 2.0 ?????

9. Trouble getting a VB3/Access Jet 2.0 DB App to run in NT4.0

10. migration vb3.0: from access 2.0 to sql server 6.5

11. VB3 -- Access 2.0 Issues

12. VB3 and Access 2.0 problem

 

 
Powered by phpBB® Forum Software