Microsoft Office Tutorials and References
In Depth Information
Finding Alternatives to Access Data Projects
sign (%). Again, because the query gets passed through directly to SQL
Server, you must use the syntax that SQL Server recognizes.
To run a pass-through query, simply click the Run button in the Results
group of the (Query Tools) Design ribbon.
If you typed the same SQL statement in a non–pass-through query, the
Access equivalent would be
SELECT * FROM dbo_tblContacts WHERE LastName Like ‘J*’
In the preceding Access example, you must use the table name as it appears
in the Navigation Pane — with the dbo_ prefix. This query wouldn’t work
as a pass-through query, because dbo_tblContacts doesn’t exist on the
server.
When you’re using pass-through queries, always type the SQL statement
with the syntax that the ODBC data source recognizes. Also, use the table
names as they appear on the server.
Finding Alternatives to Access Data Projects
If you’re a user of Access 2000 through 2010, you may be familiar with
Access Data Project (ADP) files — Access data files that provide access to
SQL Server databases. Access 2013 drops support for the ADP format, and
Microsoft recommends one of the following alternatives:
Continue using the same version of Access. ADPs continue to work in
earlier versions of Access. They won’t work, however, with newer
versions of SQL Server such as SQL Server 2012 and SQL Server Azure.
If you upgrade (or your organization upgrades) to versions of SQL
Server newer than your current version of Access knows about, your
ADPs will no longer function properly.
Convert to an Access Custom Web App. In Access 2013, you can import
your tables into a new Access app, and Access automatically creates
forms for your application. You can extend the functionality of the base
forms that Access creates for you so that other people can use your
application on the web. Although some of the functionality that you use
in ADPs may no longer be available, expect Microsoft to continue to
focus improvements in the product on this application type.
Book IX, Chapter 3 covers Custom Web Apps.
Convert to a linked desktop database. Access 2013 continues to support
creating desktop databases in .accdb file format. You can convert your
application to the .accdb format — including all your existing forms
and reports — and leave the data in SQL Server. Then you can link to
Search JabSto ::




Custom Search