MSDE

  • Thread starter Thread starter TC
  • Start date Start date
T

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
 
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 :o(
 
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.
 
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
 
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.
 
Back
Top