HiTechCoach | Access Tutirials, TIPs, Examples
You are here:
Microsoft Servers - Back Office
Microsoft SQL Server
Microsoft SQL Server
Beginner's Guide to ODBC - UtterAccess
This is an attempt to equip the developers who want to use Access as a front-end client to any RDBMS (Relational DataBase Management System) backend (ie, SQL Server, DB/2, Oracle, MySQL, PostgreSQL) with the right questions to explore and ask during design and development. As we cannot cover every special case or all the nuisances that each developers must deal with, it is hoped that,by reading over this document, you will be better equipped to find the needed answers for your specific case. The article assumes that you are familiar with developing an Access application, understand the fundamentals of data types used in Jet and VBA and know basic SQL and is familiar with Data Access Objects (DAO) library and/or ActiveX Data Objects (ADO) library, but are otherwise new to working with ODBC data sources. The objective is to provide you with a set of questions about design and development and know how to ask them.
Microsoft SQL Server Site - MSDN
Get all the latest information from Micrsoft
SQL SERVER OVERVIEW - UtterAccess WIKI
SQL Server is Microsoft's Enterprise level server database product. We'll begin our introduction to SQL Server by discussing how the database engine and storage differs from all "Access" implementations, with which you may be familiar.
Using DSN-Less Connections
Typically, linking an Access front-end to tables in some other DBMS involves using a Data Source Name (DSN), usually created through the ODBC Data Source Administrator windo, which is accessible from the Windows Control Panel (or Administrator Tools in Windows 2000). However, this requires that a DSN be created for each workstation that's going to use the front-end application.
What are the main differences between Access and SQL Server?
This article will try to explain some of the differences between Access and SQL Server.
SQL Server 2008 R2 Express
Learn, Develop, and Deploy at No Cost Build and deploy web, desktop, and small server applications for free with Microsoft SQL Server 2008 R2 Express.
Microsoft SQL Server Migration Assistant for Access v5.1
Overview SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server. SSMA for Access v5.1 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Code Named "Denali", and SQL Azure.
Microsoft SQL Server Migration Assistant for Access v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.
When to Use SQL Native Client
When deciding whether to use SQL Native Client as the data access technology of your application, you should consider several factors.
Installing and Upgrading to SQL Server 2005 - SQL Sever Central
Before you go anywhere with SQL 2K5, you must be aware of the many changes and improvements to installing the software, as well as the types of installations used in various scenarios.
Installing SQL Server 2005 - MSDN
The SQL Server 2005 Installation Wizard is Microsoft Windows Installer-based, and provides a single feature tree for installation of all Microsoft SQL Server 2005 components: ...
Installing SQL Server 2008 - MSDN
How to: Install SQL Server 2008 R2 (Setup) - MSDN
Installing SQL Server 2008 (SQL Server Video) - MSDN
Security Considerations for a SQL Server Installation - MSDN
SQL Server 2008 R2 - Security is important for every product and every business. By following simple best practices, you can avoid many security vulnerabilities. This topic discusses some security best practices that you should consider both before you install SQL Server and after you install SQL Server. Security guidance for specific features is included in the reference topics for those features.
Planning a SQL Server Installation - MSDN
SQL Server 2008 R2 - To install SQL Server, follow these steps: Review installation requirements, system configuration checks, and security considerations for a SQL Server installation. Run SQL Server Setup to install or upgrade to a later version. Use SQL Server utilities to configure SQL Server.
Quick-Start Installation of SQL Server 2008 R2 - MSDN
The Connection String Reference
SQL Server Functions - MSDN
Page 1 of 2
ACC2000: How to Build a Visual Basic Module to Print a Report in Landscape Mode on Legal-Size Paper
Office Template Store
What happens to those free Windows 10 upgrades after July 29, 2016?
Preview a Report and move to last page
Deploying Application (Front End) Updates
Microsoft Most Valued Professional MVP - Access Expert
Trust Center in Access 2007, 2010, 2013, and 2016
Why are there not many articles or examples for Access 2007, 2010, and 2013?
Splitting your Access database into application and data
What is the Access Runtime Version?