News

Microsoft Adds Upsizing, Integration Tools to Access 2000

Editor's Note: There was a misprint in today's edition of ENT Newsline that posted the headline as "Microsoft Adds Upsizing, Integration Tools to W2K." Please note that the new features are in Access 2000, not Windows 2000.

Microsoft Corp. announced new features in Access 2000 that make it easier for users to build Access applications as a front end to Microsoft SQL Server and new tools for upsizing existing Access applications to SQL Server 7.0.

For building Access applications, new features in Access 2000 called Access Projects, allow users to create a database application with Access on the front end and a native connection to SQL Server via OLE DB on the back end. Traditional Access wizards, such as those that provide assistance in creating Forms and Reports or importing data, have been redesigned to support this client/server environment. In addition, the Access interface now supports the creation and execution of SQL Server-stored procedures and triggers.

To help IT organizations scale existing Access applications to SQL Server, Microsoft has integrated its popular Microsoft Access Upsizing Tools directly into Access 2000. With these tools, users can port their database structure, including data, indexes, defaults and counters, and table relationships to SQL Server. For example, Access Queries convert to SQL Server Views.

These tools convert Access 97 objects into SQL Server equivalents. Users of previous versions of Access, such as Access 2.0 and Access 95, can either upgrade to Access 2000 or obtain SQL Server 7.0 and use its new Data Transformation Services to import data.

Additionally, Access users can obtain SQL Server 7.0 for a limited time promotional price of about $699. -- Thomas Sullivan

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

  • Azure Cost Management Now Commercially Available for Some Tenancies

    Microsoft on Monday announced that its Azure Cost Management feature had reached the "general availability" release stage for both Azure "pay-as-you-go" customers and Azure Government tenancies.

  • Microsoft Bringing Files Restore Capability to SharePoint Online and Teams

    Microsoft on Monday announced that it's delivering its Files Restore feature for SharePoint Online and Microsoft Teams to Office 365 tenancies as early as this month.

  • Microsoft Nabs IoT Platform Provider Express Logic

    As part of its plan to invest $5 billion in IoT technologies, Microsoft this week acquired Express Logic, which provides real-time operating systems for industrial embedded and IoT devices.

  • Dealing with Broken Dependencies in SCVMM

    Brien shows you how to resolve some broken, template-related dependencies in Microsoft's System Center Virtual Machine Manager.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.