I am working at a company who is having problems with Jet.  They are
trying to access an Access97 database with both Jet 4.0 and Jet 3.51.
(Yes, I know they shouldn't do that.....)  Most things seem to go fine,
but they seem to be running into a lot of database corruption issues.
I am trying to decide whether to upgrade their entire system to Jet 4,
but I can't find any articles describing the differences between 3.51
and 4.0.  Is there a 3.51/4.0 compatibility DLL to allow you to code
against 4.0 without changing the code?  Also, if I can convince them to
do an upgrade, should they just skip 4.0 and go to MSDE?

TIA

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

The only problems with going the MSDE route is that:

1) It is difficult to install (not sure if this is a problem for you, since
it seems to be implied that all users are trying to access a single
database).  At the location that I worked at, we were trying to install a
separate copy on each PC we shipped our product to, which ended up being a
real nightmare.

2) MSDE and Jet use different dialects of SQL.  This may or may not be an
issue, depending on how much of your SQL code would have to be rewritten.
    Corollary:  You cannot use any Jet specific functions with MSDE.

--
--------------------------------------------------------------
Eric Wilson
Major: Computer Science
http://www.msu.edu/~wilsone8

"If the world is just one big simulation running on a computer,
then God is one hell of a programmer!"

In my office everyone is working with A97/SR2, but I use A2K and haven't had
any trouble at all.
I did have lots of trouble a few months ago with corrupted databases. The
problem was with the NICs; most of them relied on the RTL8029 chip and it
was fixed with a new driver we downloaded from the net.
Not that I'm an expert, but AFAIK, you cannot just upgrade to Jet 4.0, your
clients will have to move to A2K.
About Jet/MSDE .... what I've read is that MS is betting on MSDE (read: SQL)
--
HTH
'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'
   Mario Osorio  (Hot Budare)
'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'_'-'
===============================
PLEASE HELP MY VENEZUELAN BROTHERS by making a donation to the Red Cross
International.
Thousands of venezuelans are homeless due to an extremely rainy season
(some 250000 according to oficial numbers).
Thousands have also died (some 25000 according to the initial calculations).
Dios te ayude
May God help you :-[
for more info goto:
http://fullcoverage.yahoo.com/fc/World/Venezuela/
www.help.org.ve/html/english.html
www.help.org.ve/html/deutsch.html
www.help.org.ve/html/francais.html
www.help.org.ve
www.ayuda.cantv.net
www.cavecom-e.org.ve
www.globovision.com
www.eud.com
www.chevere.com
www.analitica.com
www.rctv.net
www.venevision.com
www.televen.com
www.internautas-ve.org
===============================


| I am working at a company who is having problems with Jet.  They are
| trying to access an Access97 database with both Jet 4.0 and Jet 3.51.
| (Yes, I know they shouldn't do that.....)  Most things seem to go fine,
| but they seem to be running into a lot of database corruption issues.
| I am trying to decide whether to upgrade their entire system to Jet 4,
| but I can't find any articles describing the differences between 3.51
| and 4.0.  Is there a 3.51/4.0 compatibility DLL to allow you to code
| against 4.0 without changing the code?  Also, if I can convince them to
| do an upgrade, should they just skip 4.0 and go to MSDE?
|
| TIA
|
|
| Sent via Deja.com http://www.deja.com/
| Before you buy.