Jet database vs MSDE

[Dave]

I saw some threads here mentioned about Microsoft Desktop Engine (MSDE). I have installed Access 2002. How do I know I am accessing Jet database or MSDE? Appreciate some help please.

 

[Brendan Reynolds]

Jet is the default for an MDB, MSDE is not even installed by default.

The article at the following URL is a good starting point for learning about
MSDE.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

I saw some threads here mentioned about Microsoft Desktop Engine (MSDE).

I have installed Access 2002. How do I know I am accessing Jet database or
MSDE? Appreciate some help please.

 

[Dave]

Thanks Brendan. But how do I know if MSDE is installed?

 

[Brendan Reynolds]

I don't currently have MSDE installed on my PC (I have the full version of
SQL Server instead) so I can't remember now exactly what the item on the
Start Menu looked like, but if you go to Start, All Programs, and look
through the list, you'll soon know if it is installed or not.

It is not installed by default, even if you do a complete install, so if you
set your own PC, you'd know if you'd installed it. If some one else set up
your PC, they will know.

If you're still not sure, try running the NorthwindCS.adp sample application
that comes with Office. If it fails to find an instance of either MSDE or
SQL Server, an error message will inform you of that. Or just try to install
a default instance of MSDE, following the instructions at the URL I posted
previously. It will soon tell you if a default instance is already
installed.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[DAVE]

THANKS AGAIN. THE LINK YOU PROVIDED IS VERY HELPFUL. DO YOU HAVE OTHER LINKS THAT TALKS ABOUT THE DB CONNECTION TO MSDE ? OR DO I USE ADO METHOD ?

 

[Brendan Reynolds]

There's a link from the first article I recommended to a "HOW TO: Connect to
Microsoft Desktop Engine" KB article, and that article in turn has links to
further articles. In addition, a lot of documentation that refers to Access
and SQL Server will be equally relevant to Access and MSDE.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

THANKS AGAIN. THE LINK YOU PROVIDED IS VERY HELPFUL. DO YOU HAVE OTHER

LINKS THAT TALKS ABOUT THE DB CONNECTION TO MSDE ? OR DO I USE ADO METHOD ?

 

[Dave]

Thanks Brendan.