Is 'Jet' only available on machines with Microsoft Office installed?

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Dave » Tue, 27 Feb 2007 21:37:41


I'm writing an application that needs to run on Windows machines that don't
necessarily have Microsoft Office installed (so no Microsoft Access,
either).

Can I count on Jet being there, even if Microsoft Office isn't? (I doubt
it, but have to ask...)

I know I can automate an installation of MSDE or SQL Server Express, but
it's a simple app and I would like to just use Jet if I can be sure it will
always be there

Thanks
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Norman Yua » Tue, 27 Feb 2007 23:25:31

Jet comes with all Windows (don't know for Vista, though, but I'd think so).
However, whta does it have anything to do with MSDE/Sql Server Express: you
do not need Jet to access MSDE/SQL Server Express.

 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Ginny Caug » Tue, 27 Feb 2007 23:26:05

Dave,

Have you considered SQL Server Compact Edition:
www.microsoft.com/sql/compact. It's very small, faster than Jet, and
"installation" can be as simple as copying a few DLLs to your app folder. It
also free to deploy with your apps.

--
Ginny
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by NU_Dav » Tue, 27 Feb 2007 23:48:18

Thanks Norman. I was thinking about Jet as an alternative because I didn't
want to get into the hassle of ensuring that MSDE or SQL Server Express are
on the target system. I could get away with writing for Jet, but didn't
know if it came in with Office, and I don't want to require that clients
have Office running on their machines.

Now that you've told me that Jet comes in with Windows, I'm all set.

Thanks!

Dave






so).
you


doubt
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by NU_Dav » Tue, 27 Feb 2007 23:50:47

Thanks Ginny!

I was looking at Jet because I didn't want to go through the hassle of
wrapping MSDE or "SQL Server Express" installations into my installer...

I didn't know about "Compact Edition" - I'll definitely look into that.

Dave






It


doubt
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Ginny Caug » Wed, 28 Feb 2007 00:01:08

Dave,

I think you'll like it. I'm using it a lot these days for local storage for
desktop apps as well as on-device storage for mobile apps.

--
Ginny
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Bil » Wed, 28 Feb 2007 09:10:32

I would NOT depend on JET being installed anywhere. It's definitely not
supported on Vista 64 bit.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Andrew D. » Thu, 01 Mar 2007 06:45:27

In message < XXXX@XXXXX.COM >, Dave
< XXXX@XXXXX.COM > writes

Sorry to but in but the other poster is wrong...

The JET drivers are NOT guaranteed to be installed on your destination
PC (unless a version of Office is present). You can't even guarantee
that the correct version of MDAC is installed on your target PC. The
problem gets even more complicated when it comes down to different
versions of Windows.

Lets deal with MDAC first (Microsoft Data Access Components):

MDAC is basically where the ADO objects live. Prior to XP you can almost
guarantee version 2.1 of MDAC will be installed. With XP this can be
version 2.6 to 2.8 inclusive. And then there is the service packs to
these versions which depends on whether people having been running
Windows updates. If you have used 2.8 in your program and only 2.1 is
installed then your program is not going to run.

There are installers available on MSDN for all versions of MDAC (EXE's
and MSI's) however, XP does NOT like to install 2.6 onwards unless via
Windows Update.

Now as for the JET drivers - contrary to popular belief - they are NOT
included with any version of MDAC. However, there are installers for the
JET drivers (EXE's and MSI's) available on MSDN. I believe some later
service packs for Outlook Express install them.

I would therefore suggest you include these redistributables with your
software.

The other alternative is use a proper package builder like Install
Shield or WISE which can include and subsequently install them if
required or the target PC.

Kind Regards,
--
Andrew D. Newbould E-Mail: XXXX@XXXXX.COM

ZAD Software Systems Web : www.zadsoft.com
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Tom Libb » Sun, 01 Apr 2007 08:14:45

The Compact Edition is single user only. So if you need multi user access
then it is not an option.

Tom
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Ginny Caug » Sun, 01 Apr 2007 08:34:30

Tom,

SSCE is single user only on a network share. Multiple thread or apps can
access the same database at the same time on a local disk.

--
Ginny
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Aaron Kemp » Thu, 03 May 2007 03:47:43

Jet hasn't been included with office, mdac or windows for the past decade.

yes, of course JET is not worth it

Use SQL Server




don't
will
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Aaron Kemp » Thu, 03 May 2007 03:47:56

WRONG




so).
you


doubt
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Aaron Kemp » Thu, 03 May 2007 03:48:31

SQL Server isn't a hassle compared to Jet.

Jet requires Compact and Repair-- I mean seriously

lose the training wheels-- no wonder all the jobs are going to India!





didn't
are




but
 
 
 

Is 'Jet' only available on machines with Microsoft Office installed?

Post by Aaron Kemp » Thu, 03 May 2007 03:48:43

thank you Bill




rights.
---------------------------------------------




doubt
but