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

  • Feds Takes Action Against Russian Firms for Spying

    The U.S. Department of the Treasury has issued sanctions against Russia and a handful of Russian organizations for spying and other cyberactivities.

  • Microsoft Previews 64-Bit OneDrive Client for Windows 10

    A preview of a 64-bit OneDrive client for x64 Windows 10 systems is now available for work, school or home users.

  • The 2021 Microsoft Product Roadmap

    From Windows 10X to the next generation of Microsoft's application server products, here are the product milestones coming down the pipeline in 2021.

  • Microsoft Adds Data Loss Prevention Alerts to Compliance Toolbox

    The latest part of Microsoft's overall compliance tooling is its Data Loss Prevention Alerts Dashboard, now generally available.