Process SQL On A Database Server By Using A Pass-Through Query
- Topics:
- Software tips
- Tags:
- Data Management,
- SQL,
- Software,
- Microsoft Office,
- Microsoft Corp.,
- Hardware,
- Enterprise Software,
- Databases,
- Database Server,
- Database Management System,
- ...
- Source:
- Microsoft
FREE Registration is required
Overview: You can use Microsoft Office Access 2007 as a tool in which to create and modify a database and work with its data, but you can also use Office Access 2007 as a front end (interface) for a server database management system, such as Microsoft SQL Server. Generally, when you use Office Access 2007 as a front end application, you link to tables that are in the server database management system, and then use those linked tables as if they were located in the Access database. The Structured Query Language (SQL) processing is performed on your local machine by Access. To process SQL on a database server computer, use a pass-through query, the information on which can be found in this paper.
(Is this item miscategorized? Does it need more tags? Let us know.)
Format: HTML | Pages: 7
People who downloaded this item also downloaded
 |
How do I... Transfer data from a Word form to an Access database? |
 |
From Access To Excel: Quick Financial Charts |
 |
Create and manipulate Microsoft Access forms with VBA |
