MSDE

[TC]

Access is what lets you run forms & reports. >It does not actually store the
data.< That is the job of an underlying "database management" program.

Access comes with a default database management program called Mcrosoft Jet.
MSDE and SQL*Server are two alternative (other) database management programs
that you can access, using Access! (if you get what I mean)

HTH,
TC


MSDE and SQL Server

 

[Eva]

Hi,

Im new to development and i just have a quick question
regarding MSDE and access.

I intially developed a .mdb databse but i was told to use
msde so i could use stored procedures.

I was told to use the access upsizer wizard to do this.
I did this and i now have a database that has an
extension .adp (access project).

Does this mean i am running on msde now and that i can
use sprocs and other sql server tools?

im confused because i am still accessing my database
through access!!!!

Can anyone plz explain to me whats goin on. Im very
confused now (

 

[Duane Hookom]

You should have notice a difference in your database window. Your object
include collections directly from your MSDE database. An ADP is an Access
front end to an MSDE or SQL Server backend.

 

[Eva]

i see. so i am actually using MSDE then?
I thought i was still using access due to the interface!!
All the books i have seen give code examples for SQL
server. Is the coding and syntax the same for MSDE. i.e
if i wanted to write sprocs and other queries?

thx for your quick responce

 

[Duane Hookom]

Your MSDE can run the same code as SQL Server. I would suggest that consider
asking MSDE and similar questions in the queries news group where Tom
Ellison hangs out more frequently.

 

[Eva]

So MSDE does not have an interface of its own?
It has to use access as the front end?

thx

 

[Duane Hookom]

If you have a license, you can use SQL Enterprise Manager. There are some
3rd party tools (some free) that allow you to maintain your databases. Try
this link or do your own search in google
http://www.webattack.com/Freeware/webpublish/fwdbquery.shtml