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

  • Vendors Issue Patches for Linux Container Runtime Flaw Enabling Host Attacks

    This week, the National Institute of Standards and Technology (NIST) described a high-risk security vulnerability (CVE-2019-5736) for organizations using containers that could lead to compromised host systems.

  • Windows 10 Version 1809 Users May Get Visual Studio Crashes

    Microsoft on Friday issued an advisory for Windows 10 version 1809 users about possible Visual Studio crashes.

  • Standardizing the Look of Outlook's Outbound Messages

    Microsoft typically gives users a blank canvas to compose new e-mails in Outlook. In some corporate environments, however, a blank canvas isn't a good thing.

  • Windows 10 'Semiannual Channel Targeted' Goes Away This Spring

    Microsoft plans to slightly alter its Windows servicing lingo and management behavior with its next Windows 10 operating system feature update release, coming this spring.

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.