BannerAccess Class Notes  October 2005

 

This page is http://www.uaex.edu/bknox/BannerAccess_Class_Notes.htm.

We could start with General Info for using MS Access with Banner but, we are going to skip to 
Using SQLPass-Though Queries for Banner Reporting.

Other Important Things for Success with MS Access.
1.  Disk Defragmentation - is important enough to spend under $50 for an automatic solution, Diskeeper 9 Professional Edition.
2.  Without frequent defragmentation of your hard drive, your computer will soon slow down noticeably.
3.  MS Access dramatically increases the need to defragment your hard drive.
4.  A crippled version of Diskeeper is built into Windows.
  
Just do this when you leave for lunch (but don't expect it to be done when you return): 

Start>All Programs>Accessories>System Tools>Disk Defragmenter   
Highlight the C: Drive
Select Defragment

You will not want to have this "free" built-in version running while you are trying to use your computer.  You can Pause or Stop it.

5.  In your MS Access Database (i.e., BannerAccess.mdb) make sure on the Menu Bar Tools>Options>  
     under the General Tab, that "Compact on Close" is checked.

(An MS Database can easily double in size each time you open it unless you use "Compact on Close".)

6.  Your BannerAccess.mdb should be in your "My Documents" Folder. This is MS Access' preferred location; don't fight it.

Tricks you can use:
1.  Start BannerAccess using your "Run BannerAccess" Desktop Shortcut. This runs a special batch (.bat) file that sets up your connection to Banner.  
     If your Logon fails and you are sure that the ID and Password were entered correctly, then close BannerAccess and "Run BannerAccess" again.
2.  If you want to switch to a different BannerAccess (yes, some of you have several), you probably can do so without using the Shortcut. 
     Just Double-Click on the .mdb (MS Database).  But, the best way is to create a separate .bat file which I can help you do.
3.  "Refresh BannerAccess" will save your current BannerAccess.mdb to BannerAccess-1.mdb for up to nine versions.  The refreshed copy will be copied from the File Server the standard or default BannerAccess.mdb.  This is not likely what you have been using unless you are just beginning to use BannerAccess.  You can always copy BannerAccess-n.mdb and Save As BannerAccess.mdb.
4.  You need an Object from the other database or from a SavedObjectsForBannerAccess.mdb, then you have two options.
     a. Switch to the Source database and Export to the Destination database - this will automatically deleted any old object.
     b. In the Destination database, rename the old Object and Import the replacement Object.

(Warning:  Export automatically deletes your old Object.  Import can be confusing: If you Import an Object that already exists, then the new Object will be OldName+counter.  So, instead of replacing OldName with the new Object, the new Object would be OldName1, OldName2, ... incremented each time you re-Import the Object.  Not what you want.)

 

 

Other Helpful Links:

2003 Summit Session PowerPoint   Bruce Knox  and Bruce Loving

Using SQL Pass-Though Queries for Banner Reporting  the Annotated Screen Shots from Summit 2003 

BannerAccess:  861+Member ListServ  FilesSection             Brad Dennis' Demo Site Pass-Through Parameter Form 

More links from Summit 2003
  Sarah Lawrence and Malinda Richbourg UNCG - Introduction to MS Access for Banner Users 
    Session 607 PowerPoint   Reporting with MS Access and MS Excel (handout) 

     Bruce Loving
links page from the session

Using MS Access connected via ODBC to Oracle as an ad hoc reporting tool for  SCT 's Banner.

A Building Block Approach to Ad Hoc Queries  

MS Access Now  

MS Access References                                                                          MS Office  VBA  DataAccess 
MS Access SQL Pass-Through 
MS Access/Oracle Generalized Logon Form      DSN vs. DBQ
Windows 2000 ODBC for Oracle8  
MS Access 2000 Oracle ODBC LONG datatype error fix

Indiana State's FAQ - John Gallagher

BannerAccess   Listserv

IBM RS/6000 AIX (see Commands)      AIX Permissions

Oracle Dates        Oracle Documentation 

DBA Stuff    

SavedObjectsForBannerAccess_Class_Patches.mdb

SavedObjectsForBannerAccess.mdb

cellphones.mdb

 

Disclaimer

 

Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences.  The scripts and information are provided "as is" without warranty, implied or otherwise.  Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:)

Any materials posted here from other authors, all logos, images, and trademarks in this site are property of their respective owners