Maintenance

The List LU_Basin page show the allowed values for the Intake.WaterBasin field.

The List LU_Datum page show the allowed values for the Site.Datum field.

The List LU_FlaggedAtQCQA page show the allowed values for the Withdrawal.FlaggedAtQCQA field.

The List LU_PermitType page show the allowed values for the Permit.PermitType field.

The List LU_TypeOfSurfaceWaterSource page show the allowed values for the Intake.TypeOfSurfaceWaterSource field.

The List LU_TypeOfWaterUse page show the allowed values for the Site.TypeOfWaterUse field.

Links about the Website's design

The Version Notes page lists when different versions of this website were deployed and brief notes about the changes

Links about querying/reporting on database via Access Or Excel

The How To Add a ODBC Data Source to Your PC PDF shows how to create a connection between your PC and a sql server database that Access/Excel can use to read data

The How To Query SQL databases with Access PDF shows how to draw in views of data on SQL so they appear as virtual tables within MS-Access. You can then write queries and reports using this virtual tables as you normally would in MS-Access

The How To Query SQL databases with Excel PDF shows how to connect Excel to a SQL database so you can query and analyze data

The How To Update the Linked Tables From Access To SQL PDF shows how to refresh a linked table connection from Access to see alterations to table structures in SQL

The How To Edit The SQL Server Pointed To By An ODBC Data Source On Your PC PDF shows how to edit the SQL Server an ODBC data source on your PC points to

The List Field Descriptions page shows the Descriptions that can be displayed beside fields to explain what they mean

The List Users page show the users/logins active on the website. A properly authorized user can create new logins from this page.

The List Access Authorities page show the Access Authorities for the users/logins active on the website. A user must have the appropriate Access Authority to edit a table in the database from this website

The List LU_AccessAuthorityAuthority page show the allowed values for the AccessAuthority.Authority field.

The Test Website for SnowMaking is used to test new code and webpages before moving it into production.
NOTE: you can only reach the test website if you are logged into the ANR network. If you can't reach the documents on
the Y: drive, you can't reach this website.

The ERAF Summary Report is a test link to see if I can open an SSRS report via a link from a public website