- Create a database:
When creating a database, you can determine its features, including recovery mode, the number of files, and sizes for the transaction log.
Create groups of files.
Give permissions to users of the database.
You can create fields to define name, data type, etc.
You can create self-filling indexes.
You can also define relationships with other tables.
- Create views
- Create stored procedures
- Create users:
When creating users, you can define the functions of each user as well as the permissions they possess.
- Make backup copies
- Restore backup copies
- View table contents
- Create queries
There's no doubt that adMSDE will facilitate the administration of your MSDE.
Requires MDAC 2.7.