• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Views > Access Queries vs. Views

Access Queries vs. Views

If you are familiar with Access mdb queries, you already know how to create and use views. However, there are a few restrictions that apply to views, as follows:

  • Views cannot contain any parameters. You must use stored procedures to pass parameters (see Chapter 8, “Stored Procedures”).

  • In views, you cannot use any references to forms and report fields in the form of Forms!Form!Control (see Chapter 10, “Forms”).

  • Views can contain only SELECT statements. You cannot use INSERT, UPDATE, and DELETE in views.

  • There are restrictions on the sort criteria that views can contain. This means that you cannot use ORDER BY when defining a view. This restriction, however, only applies to Access 2000 and SQL Server 7. With Access 2002, you can create and execute views with sort criteria.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint