Clarification: An Access 2000 database (.MDB file) uses the Jet 4.0 database engine;
Access 97 uses Jet 3.5. Still
a file-based database engine, with many differences from the SQL Server engine.
I think there is some performance / stability improvement from Access 97 to 2000, but
not nearly as much as from
either to MSDE / SQL Server.
A separate part of Access 2000 is the Access project (.ADP file), which acts as a
front-end to a SQL Server
database. Access 2000 also includes MSDE, which is a limited, free version of sql
server 7 (limited to total of 2
GB, and no enterprise manager; but otherwise same engine).
- David
Stephen Moretti wrote:
> I believe that Access2000 uses the SQL Server database engine, so
> theoretically you should see some performance improvement.
>
> I haven't tested this, so I can't prove it. If anyone has done any testing
> it would interesting to see.
>
> Regards
>
> Stephen
>
> > -----Original Message-----
> > From: Bud [mailto:[EMAIL PROTECTED]]
> > Sent: 03 May 2001 15:11
> > To: CF-Talk
> > Subject: RE: MDAC Question
> >
> >
> > On 5/3/01, Thomas Chiverton penned:
> > > > Also is there any performance gain in converting my access databses
> > >> currently based on Access97 to Access2000?
> > >
> > >Probably not ;-)
> >
> > 2000 is more stable and less likely to eat up memory.
> > --
> >
> > Bud Schneehagen - Tropical Web Creations
> >
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development
> > [EMAIL PROTECTED]
> > http://www.twcreations.com/
> > 954.721.3452
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
