(Views are sometimes called “virtual tables.”)Microsoft SQL Server: By default, DATETIME, DATETIME2, and SMALLDATETIME data from ODBC tables is imported as the timestamp field type.
You can change the field type of a timestamp shadow field to either date or time, but the data must be structured in a specific manner.
To identify whether a table in the relationships graph is a File Maker table or from an ODBC data source, move the pointer over the arrow in the table header. You can remove fields if you do not want File Maker Pro to display them within your solution.
When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.
If you want to retain certain SQL join behavior or obtain the results of SQL predicates such as GROUP BY, create views.
Then access the data from File Maker through those views.
This white paper presents techniques for improving performance and updatability in Office Access applications that use tables linked to SQL Server.
(22 printed pages) Click here for the Word version of this article.Introduction Understanding and Addressing Performance Issues Understanding and Addressing Updatability Issues Addressing Application Logic and Coding Issues Creating Unbound Office Access Applications Conclusion Microsoft Office Access supports three primary options for connecting to data stored in Microsoft SQL Server databases: This paper focuses on the challenges encountered by Office Access developers who rely on the Office Access (Jet) database engine to connect to SQL Server over ODBC.The most common way this is done is by creating linked tables in Office Access that use the SQL Server ODBC driver to connect to tables in SQL Server databases.Andy Baron November 2006 Applies to: Microsoft SQL Server 2005 Summary: One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables.This is the type of application created by using the SQL Server Migration Assistant for Office Access.The SQL Server Migration Assistant (SSMA) for Office Access enables you to convert an Office Access database to this type of application by moving your Office Access data to new SQL Server tables and linking to these tables.