Skip navigation

New Upsizing Tools Enhance Access 2000

Microsoft announced new Access 2000 client/server features that let users more easily build Access applications as a front end to SQL Server and help IT organizations upsize existing Access applications to SQL Server 7.0. For a limited time, Access users can purchase SQL Server 7.0 for a special promotional price. The new features, Access Projects, let users 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 (e.g., for creating Forms and Reports or importing data) were redesigned to support this new client/server environment. The Access interface now supports the creation and execution of SQL Server-stored procedures and triggers, which are useful for programmability and performance. The increased integration with SQL Server 7.0 allows Access users and small businesses to take advantage of SQL Server. Access Projects extends SQL Server's world-class reliability and scalability to Access users, according to Douglas Leland, Microsoft's SQL Server group product manager. In addition, IT organizations can take full advantage of existing Access investments as a familiar interface for their end users. To help IT organizations scale up existing Access applications to SQL Server, Microsoft integrated its Access Upsizing Tools directly into Access 2000. The tools can re-create an Access database on SQL Server automatically, and users can port their database structure to SQL Server. "Microsoft Access Upsizing Tools are easy to use and have been a great time saver for us, allowing us to quickly port Access schema to SQL Server," says Daryl Bibens, sales vice president for CyberOffice Technologies LLC, which uses Access and SQL Server to develop commercial accounting and business automation applications.

TAGS: SQL Server
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.