G
Guest
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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.
MSDE? Appreciate some help please.
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 have installed Access 2002. How do I know I am accessing Jet database orDave said:I saw some threads here mentioned about Microsoft Desktop Engine (MSDE).
MSDE? Appreciate some help please.
G
Guest
Thanks Brendan. But how do I know if MSDE is installed?
B
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.
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.
G
Guest
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 ?
B
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.
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.
LINKS THAT TALKS ABOUT THE DB CONNECTION TO MSDE ? OR DO I USE ADO METHOD ?DAVE said:THANKS AGAIN. THE LINK YOU PROVIDED IS VERY HELPFUL. DO YOU HAVE OTHER
G
Guest
Thanks Brendan.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.