Microsoft Access and Microsoft SQL Server If you have a
Microsoft SQL Server database and you want to use it in a
Microsoft Access database, you have various options. You can
import the objects from the server database or you can create a
Microsoft Access project that is a database whose tables link to
the server. If you have one or more tables that are part of a
Microsoft SQL Server database but for some reason you do not
want, do not need, or are not allowed, to work directly on the
database server, you can import the objects to Microsoft Access.
You first need to create the recipient database in Microsoft
Access. Microsoft Access treats Microsoft SQL Server as one of
the ODBC family of databases (the Microsoft Windows operating
system has a driver that allows different database environments
to communicate or interact with the same database, as long as
they follow some rules of the ODBC driver; for example, an
application created with Delphi and a PHP web site both can
communicate with a Microsoft Access da