| | |
|
|
|
Jet database vs MSDE |
|---|
| message from =?Utf-8?B?RGF2ZQ==?= on 14 May 2004 |
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.
|
| =?Utf-8?B?RGF2ZQ==?= replied to Brendan Reynolds on 14 May 2004 |
Thanks Brendan. But how do I know if MSDE is installed?
|
| Brendan Reynolds replied to =?Utf-8?B?RGF2ZQ==?= on 14 May 2004 |
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.
|
| =?Utf-8?B?REFWRQ==?= replied to Brendan Reynolds on 14 May 2004 |
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 replied to =?Utf-8?B?REFWRQ==?= on 14 May 2004 |
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.
|
| =?Utf-8?B?RGF2ZQ==?= replied to Brendan Reynolds on 15 May 2004 |
Thanks Brendan.
|
|
Archived message: Jet database vs MSDE (Microsoft Access Database)
