Access Stored procedures

[Eva]

Hi,

I wanted to know how i can create stored procedures in
Access. Is this possible or is it worth me using MSDE??

Is there an easy way to move my existing Access database
to MSDE database?

I am a complete beginner in this area so any advise would
be grateful

 

[Douglas J. Steele]

Access doesn't have stored procedures. MSDE, being SQL Server "lite" does,
though.

You should be able to use the upsizer to convert the data from your MDB to
MSDE, or check http://www.ssw.com.au/ssw/UpsizingPRO/Default.aspx

 

[Eva]

Is MSDE just as easy to use as access?? is it another
type of DBMS??
as u can see, im not too clued up on this topic!!!