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.
 
So MSDE does not have an interface of its own?
It has to use access as the front end?

thx
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Data provider could not be initialized 1
Stored Procedure in SQL Server vs MSDE 2005 SQL Server 2
Data corruption with SQL server installed 9
DataBase Programming 5
Am I disturbing a machine in production floor if I access its database remotely? 4
Help - MSDE or Jet for Stand-alone App, 3
newbie - VB.net and MSDE / JET question 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Back
Top