Use access to improve Enterprise Manager features

Access-specific SQL Enterprise Manager (SQL Enterprise manager). (Note: The software is free only if you have Microsoft Office 2000 or XP licenses.) )

Many companies that use SQL Server also use Office, and most of these companies have office-licensed versions that contain access. In such a company, you can create a Microsoft Access Project (ADP) file that provides a direct connection to SQL Server.

Once you create an ADP file, you can do a variety of things in Enterprise Manager, including creating tables, searching, storing programs, and user-defined functionality. However, you cannot build and execute DTS packages, and cannot establish registrations and responsibilities, because Access does not replace Enterprise Manager for these features.

Follow these steps to establish this ADP tool (this tool applies only to Access 2000 or Access XP):

1. Create an ADP associated with the SQL database according to your choice. Make sure that the connection between them is successful, and the success of the connection depends on a number of factors, such as integration or standalone registration.

2. View the data window in Access. If you are using Access 2000, you will see a separate label for the query (Queries) and the stored program (Stored procedures). If you are using Access 2002 (XP), these two tags will be combined into one.

3. Create a new stored program or a view. You can see a wizard and a graphical environment in which you can drag around, double-click different columns for different tables, and add tables automatically. When you build a structure, such as select Top 10 ..., this environment is quite useful. No one has said that a graphical interface can accomplish anything, but you can use it to accomplish a lot of things.

4. Create a scalar (scalar) or a table function (table functions).

5. Follow the prompts and create the required functions. Although these features are simple, they can give you an emotional understanding of the tool.

The role of Enterprise Manager is more for maintenance than for development. Many other companies provide the tools, but the costs of those tools are very high. Even if you get permission from these Third-party products, you should check the access ADP file before you use it. If you're lucky, you can get all the features you want, and these features are free.

The real question is: Why did Microsoft remove the ADP file in Access 2003? It's probably because the ADP file is so good that the Enterprise Manager is dumb to compare it to, or maybe it's because Yukon is a whole new change that requires a complete, important writing of the relevant code. If that's what you think, then your phase is the same as mine.