MSDE works just like SQL Server - it really IS SQL Server for all practical
purposes (not counting database sizes, and other stuff). So, SP's are
certainly supported, as are triggers, constraints, indexes, etc.
When you open an Access project that is linked to a SQL Server DB, the
left-hand menu contains:
Tables
Views
Database Diagrams
Stored Procedures
Forms
Reports
Pages
Macros
Modules
Right-clicking on a table gives you the option to build triggers.
Right-clicking on a field and selecting Properties lets you set
relationships, constraints and indexes.
BTW- the table design mode looks just like Enterprise Manager.
It works pretty well - try it :)
Jeff
-----Original Message-----
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 21, 2000 7:34 PM
To: CF-Talk
Subject: Re: MSDE on Win2K... anyone successfully install it?
> MSDE appears to the developer exactly like SQL Server. It does not come
> with SQL Enterprise Manager, so you'll either have to get a copy of that,
or
> use MSAccess 2000 as the front end. Using Access, you'll set up a Project
> that connects to the MSDE engine. The nice thing about using Access is
you
> have the query by example tools, making query development very easy.
Does MSDE support things like stored procedures? If so, and you're using
Access 2000 as the front end, then are the necessary tools available within
Access to develop or install stored procedures?
Jim
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
