The Free Access Web App Reference from Access MVP Crystal Long

You can now see or download Crystal's 2015 Microsoft MVP Virual Conference session video on Channel 9! See the Using Access and SharePoint for Travel Expenses and Pulling up Maps - CONS Track Day2 session featuring Access MVPs Crystal Long, Julian Kirkness, and Brent Spaulding!

Download Crystal's PowerPoint Presentation File with Links used in the 2015 Microsoft MVP Virual Conference session Using Access and SharePoint for Travel Expenses and Pulling up Maps. Updated 7/20/2015.

For anyone who wants captions for this session you can you can download this SRT file Captions_AccessVConf_English_SRT.zip and play captions on your computer.

For those who want to read what was said in the session here is a transcript file you can download: Transcript_2015_Microsoft_MVP_Conference_Access_DOCX.zip

Learn How To Migrate Data from Desktop Access Databases to Access Apps with a new Video by Crystal. Perhaps you only want to web-enable the part of a database. Take advantage of new features that Access now gives us. How To Migrate Data from Desktop to Access App (cc) 32:35.

Download Crystal's free Access Web App Reference Word Document This is a Word file you can use as a Reference when developing Access 2013 Web Apps.

Download Crystal's free Word document with XML for Access macros This is a zipped Word document with XML that you can copy and paste into the macro designer (then customize for your names). As with other resources on this page, it will be updated as time goes on.

Crystal's free Access Web App Reference Database will be available to download when it is ready. The Access Web App Reference Database is an Access Desktop database. So that you automatically get the latest updates the Tables are Linked Tables in an Azure SQL Database. When it is available all you will need to do is Download the Front-end. If you do not have SQL Server installed make sure you have installed the Microsoft SQL Server 2012 Native Client or the Microsoft ODBC Driver 11 for SQL Server for Windows on your computer. Installing the Required SQL Server Driver

Both the Access Web Reference Word Document and the Access Database is a reference for the following subjects:

  • Tables
  • Fields
  • Queries
  • Views (Web App Forms)
  • Reports
  • Framework of Web Apps
  • Macro Actions
  • Expressions and Expression Builder
  • Built in Functions
  • Functions
  • Arguments
  • Control Types
  • Properties
  • Events
  • Application Icon
  • Web App URL
  • Creating a Desktop Database for Reporting
  • Reserved Words
  • Documenting the Web Database
  • Using Crystal's Free Analyzer for Microsoft Access on CodePlex

Download the Updated version of Analyzer for Microsoft Access that can analyze report databases created by Access Apps now on CodePlex.

More information will be added so come back often to get the latest Word Document.

See Crystals Tutorials, Videos, and free Databases
Visit Crystal's Access MVP Web Page.


A Grow-up Path for Access Web Apps: How to migrate Schema and Data from an Access Web App Azure SQL Database to SQL Server or a stand-alone Azure SQL Database.

Use the Generate Scripts Wizard in SQL Server Management Studio to get SQL scripts to migrate Tables and User-defined Functions.

------------------------------------------------------------------------------
YOU CAN USE SQL SERVER MANAGEMENT STUDIO TO GET THE SQL TO CREATE OTHER
USER CREATED OBJECTS SUCH AS VIEWS AND TRIGGERS USING THE SQL BELOW
*THE SQL TO CREATE THE OBJECTS IS IN THE definition OR VIEW_DEFINITION COLUMN.
------------------------------------------------------------------------------

------------------------------------------------------------------------
Note: Often Access Schema Objects require AccessSystem Objects to work.
------------------------------------------------------------------------

------------------------------------------------------------------------
VIEWS
------------------------------------------------------------------------
--User Created VIEWS --This only gets Views Created by User Development Activity.
SELECT VIEW_DEFINITION FROM [INFORMATION_SCHEMA].[VIEWS]
	WHERE TABLE_SCHEMA <> 'AccessRuntime'
	ORDER BY TABLE_SCHEMA, VIEW_DEFINITION


--User Created AND AccessSystem VIEWS (alternative sql)
SELECT	s.definition, v.name, v.type, v.type_desc, v.is_ms_shipped, sc.name AS SchemaName

FROM    sys.all_sql_modules AS s 
            INNER JOIN sys.views AS v 
                ON s.object_id = v.object_id 
            INNER JOIN sys.schemas AS sc 
                ON sc.schema_id = v.schema_id

WHERE   v.is_ms_shipped = 0
        AND (sc.name = 'Access' OR sc.name = 'AccessSystem')

ORDER BY SchemaName, v.name
----------------------------------------------------------

------------------------------------------------------------------------
--"CREATE" SQL FOR OTHER OBJECTS YOU MAY WANT TO MIGRATE.
------------------------------------------------------------------------

SELECT s.definition, o.name, o.type, o.type_desc, o.is_ms_shipped, sc.name AS SchemaName

FROM    sys.all_sql_modules AS s
            INNER JOIN sys.all_objects AS o
                ON s.object_id = o.object_id
            INNER JOIN sys.schemas AS sc
                ON sc.schema_id = o.schema_id

WHERE sc.name = 'Access' OR sc.name = 'AccessSystem'

ORDER BY o.type, sc.name, o.name;

------------------------------------------------------------------------

--is_ms_shipped indicates whether an Object is created by an internal SQL Server component or by a user. Source: sys.objects (Transact-SQL)

Information on Web App Azure SQL Database Objects: Access 2013 and SQL Server by Andy Stegmaier  

Information about the SQL used:
------------------------------------------------------------------------
type   type_desc
------------------------------------------------------------------------

FN     SQL_SCALAR_FUNCTION                 Scalar-valued Functions
IF     SQL_INLINE_TABLE_VALUED_FUNCTION    Inline Table-valued Functions
P      SQL_STORED_PROCEDURE                Stored Procedures--Web App Data Macros.
TF     SQL_TABLE_VALUED_FUNCTION           Table-valued Functions--Web App Queries with Criteria.
TR     SQL_TRIGGER                         Triggers--Web App Table Event Macros.
V      VIEW                                Views--Web App Queries.

We will be adding more information on Migrating Web App Azure SQL Databases so come back again.
                        

Visit the Microsoft Access and SQL Azure Information Center for Developers to learn how to use Access with tables in an Azure SQL Database.



Login Status: Not logged in.
Login      Free Registration

  Call Us for a Free Consultation

Phone:

Email:

Share

Site Navigation

Skip Navigation Links.
Return to Top