MDAC or Jet?

[hula]

Hallo

i am planing to develop an application in C# (VS2005) that uses an
Access 2000 Database as backend only for storing data. The frondend is
written completly in C#.

My question is, what do i need to deploy to the customers so they can
access the mdb file?
Do i need Jet 4.0? or MDAC 2.8?

My connect string says:
Microsoft.Jet.OLEDB.4.0
so i would guess Jet, OLEDB however would suggest MDAC.

Many thanks in advance.

 

[Douglas J. Steele]

Actually, you need both.

MDAC 2.5 was the last version of MDAC to include the Jet drivers, so you
need Jet 4.0 installed to insure you've got them.

 

[hula]

Actually, you need both.

MDAC 2.5 was the last version of MDAC to include the Jet drivers, so you
need Jet 4.0 installed to insure you've got them.

Thank you

i'll have to put both on the CD then

A pitty that there dose not exist MergeModules for MDAC nor Jet for
VS2005 ...

 

[susiedba]

ROFL

MDAC was the last version of MDAC to include the jet drivers; so why do
you kids still use an obsolete database format?

-Susie, DBA

 

[hula]

ROFL

MDAC was the last version of MDAC to include the jet drivers; so why do
you kids still use an obsolete database format?

-Susie, DBA

? What do you mean?
I will for sure not install/deplay MDAC 2.5. This is to old.
And why is Access an obsolet database format?
Would you recommend something else? My database will hold just up to
50000 rows so sql-servr-express is prety oversized (although i would
prefer it) and has no automatic installation mode

 

[Larry Linson]

? What do you mean?
I will for sure not install/deplay MDAC 2.5. This is to old.
And why is Access an obsolet database format?
Would you recommend something else? My database will hold just up to
50000 rows so sql-servr-express is prety oversized (although i would
prefer it) and has no automatic installation mode

If your users do not have it already, but want Jet support, you'll need to
install MDAC 2.5 because that's the last version of MDAC that included it.
I thought that was clear from an earlier post.

50,000 records is child's play for a Jet database; users regularly report
running hundreds of thousands, even millions of records, with adequate
performance.

"Susie, DBA" is an alias of someone who trolls these databases under several
different aliases, looking for arguments, so you can safely ignore his
comments.

Larry Linson
Microsoft Access MVP