Conrad Systems Development

Conrad Systems Development


  Home

  B.O.$.$

  Client List

Access Information
  Resources
  Calendars
  Corruption
  App Close Button
  Macro Security
  Kick Them Off
  Database Splitting
  Combo Boxes
  Tab Colors
  Progress Bars
  Backgrounds
  Navigation
  Command Buttons
  References
  Demo Database
  Form Resize
  TreeView Control
  Switchboard FAQ
  Matching Games
  Top 10 Lists
  CSD Tools
  Technical Articles
  Document Tables
  Calculators
  Shift Key Bypass
  Epson Printer Info
  Newsgroup Help

  Contact Us


                                 Access Junkie's Resource List
                             

This is my list of Access Resources I have compiled over the last several years. I hope you find this list as useful as I have. Use this page as a starting point when you need to find anything related to Access.

List last updated: March 5th, 2013

  - New entry since last revision
  - Link updated since last revision
- Access MVP site


Table Of Contents

Starting Out Ten Commandments  KB Articles
Netiquette  Database Design 101 Naming Conventions 
Reserved Words Interface Design  Microsoft Templates
Tutorial  Database Models Downloads 
Stephen's Site Advanced Topics  Miscellaneous
Articles  Run Commands Other Links 
Add-Ins/Utilities Access Chats  User Level Security
Menu Bars/Tool Bars  Replication  Access Forums 
Book Recommendations  Publications  Access Blogs 
User Groups  MVP Sites  Database Recovery 

 

Link Count as of Last Update: 431

 

Starting Out with Access:

Number One on your start list for comprehensive Access help: 

  http://www.mvps.org/access/


Top Top

 

Access Ten Commandments:

Follow the wisdom and do not stray towards the Dark Side.

"...fear leads to anger, anger leads to hate, hate leads to Lookup Fields."

  http://www.mvps.org/access/tencommandments.htm

  http://www.accessmvp.com/djsteele/AccessTenCommandments.html

http://www.3nf-inc.com/Access10.htm





Top Top

 

Microsoft Knowledge Base Articles:

Main Page for searching:
http://search.support.microsoft.com/search/?adv=1

How to use the Knowledge Base:
http://support.microsoft.com/?id=307760
http://support.microsoft.com/?id=304880

http://support.microsoft.com/?id=307759

List of Access KB Articles:
http://www.aadconsulting.com/kb/kbarticles.htm

   


Top Top

 

Netiquette for newsgroup postings:

Netiquette:
  http://www.mvps.org/access/netiquette.htm

How to ask a question:
http://support.microsoft.com/kb/555375

mvp.jpg (771 bytes) Making Good Newsgroup Posts:
http://dts-l.org/goodpost.htm

How to ask in a newsgroup:
http://www.michna.com/kb/Newsgroups.htm

The Lost Art of Etiquette:
http://www.clintonfitch.com/editorials/102005/lostart.asp

Why and How to Crosspost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

Using the Newsgroups Effectively:
 
http://tc2.atspace.com/0012-UsingUsenet.htm

 


Top Top


Database Design 101:

Understanding Normalization by Michael Hernandez:
ZIP File Download

Database Design Tips by Michael Hernandez:
Database Design Tips.zip

ACC: Database Normalization Basics
http://support.microsoft.com/?id=100139
http://support.microsoft.com/?id=209534
http://support.microsoft.com/?id=283878  

Glossary of database terms:
http://www.dhdursoassociates.com/database-glossary-3.html

Where to find information about designing a database in Microsoft Access:
http://support.microsoft.com/?id=289533

"Understanding Relational Database Design" Document Available in Download Center:
http://support.microsoft.com/?id=283698
http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"
http://support.microsoft.com/?id=234208

Fundamentals of Relational Database Design:
http://support.microsoft.com/?id=129519

http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Data Normalization Fundamentals by Luke Chung:
http://www.fmsinc.com/tpapers/datanorm/index.html

Support WebCast: Database Normalization Basics
http://support.microsoft.com/default.aspx?scid=/servicedesks/
webcasts/wc060600/wcblurb060600.asp

Concepts Of Database Design And Management:
http://www.sitepoint.com/article/database-design-management

Database Design And Normalization (aimed at dBase, but still valid):
http://www.jpmartel.com/bu12_c.htm

Database Normalization:
http://burks.bton.ac.uk/burks/foldoc/35/28.htm

Introduction To Data Modeling:
http://www.utexas.edu/its/windows/database/datamodeling/index.html

Access Data "Clean-up" Tips:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=182

Defining relationships between tables in a Microsoft Access database:
http://support.microsoft.com/?id=304466
http://support.microsoft.com/kb/304467/
http://support.microsoft.com/kb/304468/

Database Normalization Techniques:
http://databases.about.com/od/specificproducts/a/normalization.htm 

Introduction to Database Normalization:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html 

Database Normalization:
http://en.wikipedia.org/wiki/Database_normalization

  MVP Crystal Long's Access Basics document:
http://www.allenbrowne.com/casu-22.html

  Data Modeling 101 by George Hepworth:
http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf 

  A Little Treatise on Normalization by Access MVP Jerry Dennison:
http://tinyurl.com/hczcd 

  Fully Qualified Naming - The First Step To Normalization by Access MVP Jerry Dennison:
http://tinyurl.com/frgb3 

  Glossary of Terms and Definitions by Access MVP Jerry Dennison:
http://tinyurl.com/jow3q 

General Database Design Topics and Articles:
http://www.databasedev.co.uk/general.html

Rules of Data Normalization:
http://www.datamodel.org/NormalizationRules.html

Normalization Rules - Beyond The Third Normal Form
http://www.curlingstone.com/Normalization2.html 

Normalization:
http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/contents.html

Normalization:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html

Advanced Normalization:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html

Overview of Normalization:
http://www.gslis.utexas.edu/~wyllys/DMPAMaterials/normover.html

Normalization:
http://db.grussell.org/section008.html

Normalization – BCNF:
http://db.grussell.org/section009.html

A Simple Guide to Five Normal Forms in Relational Database Theory:
http://www.bkent.net/Doc/simple5.htm

Introduction to Relational Databases - Part 1: Theoretical Foundation:
http://www.15seconds.com/issue/020522.htm

On DK/NF Normal Form:
http://www.dbdebunk.com/page/page/621935.htm

Database eLearning:
http://db.grussell.org/index.html

ACC: General Initial Planning Phase For A New Database Part I:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041 

ACC: General Planning a database – Part 2:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586 

Database Design Strategies:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932 

Normalizing a Database:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208 

Indexes - Info and Links:
http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994

SQL Tutorial:
http://www.1keydata.com/sql/sql.html

Data Warehousing and Business Intelligence:
http://www.1keydata.com/datawarehousing/datawarehouse.html

 

 


Top Top



Naming Conventions:

http://www.xoc.net/standards/rvbanc.asp

mvp.jpg (771 bytes)  http://www.mvps.org/access/general/gen0012.htm

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/
dnaraccess/html/msdn_20naming.asp


http://infocom.cqu.edu.au/Courses/2001/T5/COIT13143/Resources/lrnamstd.rtf

   http://www.granite.ab.ca/access/tablefieldnaming.htm

Object Hungarian Notation Naming Conventions for VB:
http://support.microsoft.com/kb/q173738/

 


Top Top

 

Reserved Words:

  Problem names and reserved words in Access:
http://allenbrowne.com/AppIssueBadWord.html

  Validate Names to Make Sure They Aren't VBA Keywords:
http://www.trigeminal.com/codes.asp?ItemID=18#18

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Reserved Words in Microsoft Access
http://support.microsoft.com/?id=109312
http://support.microsoft.com/?id=209187
http://support.microsoft.com/?id=286335

List of Reserved words in Jet 4.0
http://support.microsoft.com/?id=321266

http://geocities.com/jholimpo/
(Click on PDFs on the left side and select “Reserved Words”)

http://tinyurl.com/ze6q8

 

 


Top Top



Interface Design Topics:

http://www.isii.com/ui_design.html

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
(User Interface Guidelines)

Official Guidelines for User Interface Developers and Designers:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwue/html/welcome.asp

http://www.databasedev.co.uk/user_interface_design.html

 


Top Top



Microsoft Database Templates:

http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=database


Top
Top

 

Tutorial Style:

  http://www.rogersaccesslibrary.com/Tutorials.html

  http://allenbrowne.com/casu-01.html

Solutions and Orders Sample Databases:
  http://www.mvps.org/access/dow­nloads/bapp2000.exe

  Building Microsoft Access Applications by MVP John Viescas:

http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/dndbdes/html/
OfficeAccessBuildingApplicationsCh4_Book.asp

Bob Larson's Tutorials and samples:
http://www.btabdevelopment.com

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.geekgirls.com/databasics_01.htm

http://www.microsoft.com/office/previous/xp/columns/column06.asp

http://www.functionx.com/access/

http://www.bcschools.net/staff/AccessHelp.htm#Top

http://www.fontstuff.com/access/index.htm

http://www.fgcu.edu/support/office2000/access/

http://www.oit.duke.edu/ats/training/docs/access1/

http://cisnet.baruch.cuny.edu/holowczak/classes/2200/
access/accessall.html#sec_intro

https://secure.vtc.com/cd/access2003.htm

http://simply-access.com/index.php?module=Website&action=
Text&content=1103189759765-9716

http://www.datapigtechnologies.com/AccessMain.htm

SQL Tutorial:
http://www.w3schools.com/sql/default.asp

Tutorial: Analyzing Data Using Access
http://www.microsoft.com/education/AccessTutorial.aspx

http://www.accessmonster.com/Uwe/DirCat.aspx/
Access-Directory/Tutorials

http://tutorials.freeskills.com/index/category/104

List of resources that are available to help you learn Visual Basic
for Applications programming:
http://support.microsoft.com/?id=226118

http://www.profsr.com/home3.html

Intermediate Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/
en-us/dnacc2k/html/acintsql.asp

http://www.majorsoftware.com.au/Orderform.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
bapp2000/html/mdbdownload.asp

http://www.microsoft.com/resources/documentation/sql/7/
all/proddocs/en-us/msjet/jetch02.mspx

http://databases.about.com/cs/tutorials/

http://office.microsoft.com/en-us/officeupdate/CD011124301033.aspx

http://c85.cemi.rssi.ru/access/Books/A97ExSol/contents.htm

Tutorial in Spanish:
http://www.aulafacil.com/Access/CursoAccess/CursoAccess.htm

http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033&CTT
=6&Origin=RP061182801033 

http://www.ehow.com/how_13626_define-many-many.html

Interactive Online SQL Training:
http://www.sqlcourse.com/

Fundamental Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

Intermediate Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

Advanced Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp

Microsoft Access 2000 CD-ROM Training from AppDev:
http://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=AC00Product

http://www.database-design-2000.com/lesson1.htm

http://customguide.com/certification/access_training_2002/mos.htm 

Access 2003 Courses:
http://office.microsoft.com/en-us/training/CR061829401033.aspx 

Autonumbers - what they Are and Are Not...
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604

https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=73976

Access 2003 VBA Course:
http://www.learnaccessvba.com

Learn Access Now
http://www.learnaccessnow.com

Overview of Access:
http://www.hitechcoach.com/resources.htm

http://www.myaccessprogram.com/

 


Top Top

 

 

Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm


Top Top

 

 

Download Samples:

   http://rogersaccesslibrary.com/TableOfContents3.asp

  http://www.datastrat.com/DataStrat2.html

  http://www.pointltd.com/Downloads/?p=Access

  http://www.accessmvp.com/KDSnell/SampleDBs.htm

http://www.candace-tripp.com/pages/access_downloads.aspx

http://members.shaw.ca/glenk/index.html

http://www.freeaccess.de/downloads.asp
(In German)

http://www.weascend.com/Downloads/downloadpage.htm

http://www.aleksoft.net/samples/

http://www.worksrite.com/
(Click on the News button)

http://www.amazecreations.com/datafast/Download.aspx

http://www.endprod.com/db.htm

Newsgroup regular Fred Boer has graciously provided a fully-functioning library database that can be downloaded:
http://fredboer.books.officelive.com/Downloads.aspx

http://www.asken.com.au/downloads/accessdbs1.php

http://www.enflow.com/Cases/SampleSoftware.htm

http://www.databasedevelopment.co.uk/examples.htm

 


Top Top

 

MVP Stephen Leban's site:

  http://www.lebans.com/

Yes, Stephen's site deserves a category of its own.
A couple of things I have learned from Stephen:
1. If you think something cannot be done with Access, check his site first.
2. If Stephen says it cannot be done, trust me, it cannot be done!


Top Top

 

 

Advanced Topics:

  http://www.trigeminal.com/utility.asp
(Once an MVP, always an MVP in my book)

http://www.mentalis.org/index2.shtml

 


Top Top

 

Misc: Downloads/Samples/Helpful Articles

  http://www.granite.ab.ca/accsmstr.htm

  http://allenbrowne.com.au/tips.html

  http://www.viescas.com

  http://www.accessmvp.com/SDaigle/index.htm

  http://www.users.bigpond.com/papwalker/

http://www.groupacg.com/

mvp.jpg (771 bytes)  http://accdevel.tripod.com/

  http://www.scobiz.com/Presentations.asp

  http://dnn.scobiz.com/

  http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

  http://btmtz.mvps.org/

  http://tc2.atspace.com/

  http://www.access.hookom.net/

  http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

  http://home.comcast.net/~cccsolutions/accesstips.html

http://www.applecore99.com/index.asp

http://www.helenfeddema.com/access.htm

http://www.aadconsulting.com/index.html

http://ffdba.com/#downloads

http://www.liquorman.net/Tips.html

http://propertychampion.com/Developer_Tools/Addins/Addins.html

25 SQL Commandments:
http://www.dbpd.com/vault/9801xtra.htm

http://www.resources.intuidev.com/

http://www.knowhowtwo.com/Tips/access_tips.htm#Caps%20Lock%20Feature

 

 


Top Top

 

Helpful Articles/Code Samples:

  http://www.pacificdb.com.au/MVP/MVPCode.htm

  http://www.accessmvp.com/djsteele/AccessIndex.html

  http://www.ltcomputerdesigns.com

http://accesstips.datamanagementsolutions.biz/index.htm

  http://vbnet.mvps.org

  http://brenreyn.brinkster.net

mvp.jpg (771 bytes)  http://www.mvp-access.com/buho/index.htm
(In Spanish)

mvp.jpg (771 bytes)  http://www.mvp-access.com/juanmafan/
(In Spanish)

  http://accessvbafaq.mvps.org/

  http://usuarios.lycos.es/jbchea/RptCp.htm
(In Spanish)

  http://www.j.nurick.dial.pipex.com/Code/index.htm

  http://www.access.vis.pl/
(In Polish)

  http://www.access.qbuilt.com/

http://www.winsoft.sk/daofaq.htm

http://www.calvinsmithsoftware.com/HardToFindTips.htm

http://www.trevor.easynet.co.uk/AccFAQ/

http://www.theofficeexperts.com/access.htm

http://www.databasedev.co.uk/

http://www.blueclaw-db.com/ms_access_examples/index.htm

http://www.jamiessoftware.tk/

http://www.pdtech.co.uk/prod01.htm

http://www.vbexplorer.com/VBExplorer/VBExplorer.asp

http://www.heuveltop.nl/BasCB/msac_index.html

http://www.vb123.com/search/toc.htm

http://www.carlprothman.net/Default.aspx?tabid=100

http://www.logicielappui.com/tips/
(In French)

http://c85.cemi.rssi.ru/Access/ListTips.idc?AccessID=3
(In Russian)

http://www.donkarl.com/
(In German)

http://www.sitocomune.com/
(In Italian)

http://www.access.online.pt/
(In Portuguese)

http://www.mcpegasus.net/content/faqs.htm
(In Spanish)

http://archive.baarns.com/software/
(Click Developer's FAQ Page)

http://www.comriesoftware.net/codewidgets/browse.aspx?cat=1

http://www.tek-tips.com/faq.cfm?pid=702

http://www.hcts.net.au/tipsandtricks.htm

http://www.accessfreak.net/

http://www.mantuanet.it/alessandro.baraldi/
(In Italian)

http://members.cox.net/tulsaalstons/Documents/Microsoft%20Access%
20Developer%20Transition%20to%20Internet.htm
.

http://www.accessdatabasetips.com/

http://www.microsoft.com/accessdev/a-a&sa.htm

http://custom-software.biz/Ezine.htm

http://www.mile50.com/access/

http://cpcug.org/user/clemenzi/technical/Databases/MSAccess/

http://www.fabalou.com/access/access.asp

http://www.amazecreations.com/datafast/article.aspx

http://www.techonthenet.com/access/index.php

http://www.columbia.edu/~jl2402/AccessTips.html 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndbdes/html/
CHAPTER2AccessProtectionSecurity.asp 

http://www.databasejournal.com/features/msaccess/article.php/3437731 

http://www.databasejournal.com/features/msaccess/article.php/3298161

http://www.nwarwick.co.uk/Access.htm

Using MapPoint from Word, Access and Excel:
http://www.mp2kmag.com/a39--word.access.excel.mappoint.html

Tina’s Tips to Get You Going-
Basic information that applies to all databases...
http://home.att.net/~california.db/tips.html

http://vb-helper.com/index_multimedia.html

 

 


Top Top

 

Run Command Constants:

http://www.tkwickenden.clara.net/


Top Top

 

A massive list of other Access links:

  http://groups.yahoo.com/group/MS_Access_Professionals/links
(Have to be a member) 

  http://www.datacomptech.com/links.html#acc

  http://www.access.qbuilt.com/html/links.html

http://www22.brinkster.com/accessory/links.asp

http://dmoz.org/Computers/Software/Databases/MS_Access/

http://www.directory-base.com/access/

http://www.cbel.com/ms_access/

http://www.aadconsulting.com/accessres.html

http://www.utteraccess.com/links/

http://www.candace-tripp.com/pages/mainf.aspx#

http://www.vbaexpress.com/resources.php#Access

http://www.enflow.com/links.htm

http://www.yaccess.com/alph.shtm

 

 


Top Top

 

Add-Ins/Utilities:

  "CSD Tools Database Documentation"
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

"Doug Steele Object Documenter"
  http://www.accessmvp.com/djsteele/Documentor.html

"Sandra Daigle Permissions Wizard"

This is a re-write of MVP Sandra Daigle's DbUtilities which, as an Add-in, makes it easier to transfer the object permissions from a secured database to a new database container.

The Zip file also includes a complete user guide which covers installation, usage and walk-through guides.

Select the appropriate Zip file for whichever version of Access you are using.

DBUtilitiesAddin97.zip

DBUtilitiesAddin2000.zip

(255 KB)

(207 KB)


  http://www.fmsinc.com/

  http://www.granite.ab.ca/access/thirdparty.htm
(Big list here)

  http://www.appspro.com/Utilities/CodeCleaner.htm

  http://www.grahamwideman.com/gw/tech/access/permexpl/index.htm

  The ToolShed Access eBook:
www.vb123.com/toolshed/

  The WorkBench for Microsoft Access:
www.vb123.com/workbench/

  The ToolBox:
http://www.vb123.com/toolbox/

  http://groups.yahoo.com/group/MS_Access_Professionals/files/0_Utilities%20and%20Add-ins/
(Have to be a member) 

http://mphillipson.users.btopenworld.com/

http://www.moshannon.com/

http://www.rickworld.com

http://www3.bc.sympatico.ca/starthere/findandreplace

http://www.peterssoftware.com/index.htm

http://www.dbi-tech.com/default.asp

http://www.zada.com.au/accessaddins.htm

http://www.mztools.com

http://www.logico-solutions.com/

http://accesstools.narod.ru/

http://www.directory-base.com/access/index.php?
inc=20&title=Add%20Ins

http://www.skrol29.com/us/vaccess2.php

http://www.infoplan.com.au

http://www.appsplus.com/

http://www.devexpress.com/?section=/products/ActiveX/XSideBar

http://www.accessmonster.com/Access-Directory/
Tools/Access-Resources.aspx

http://www.databasecreations.com/devtools.htm

http://www.fabalou.com/fullprograms/dbutilities.asp

http://www.oaltd.co.uk/VBETools/Default.htm
(Enhances References Dialog box)

http://www.ammara.com/

http://www.exontrol.com/sg.jsp?content=products/excalendar

http://www.ssw.com.au/SSW/Download/Download.aspx?
GroupCategoryID=2ACCESS

http://www.aylott.com.au/accver.htm

http://www.osagecomputing.com/

http://www.prestosoft.com/ps.asp?page=edp_examdiff

http://www.softwareaddins.com/

http://atroplan.com/AccMemReporter.htm

http://www.compros.com.au/AS/ReadMe.html

http://archive.baarns.com/software/
(Click On-Line Catalog then Access Software)

http://www.submain.com/?nav=products.pcp

http://www.bway.net/~dfassoc/download/Access/Reconnect.html

http://www.jstarsoftware.com/index_files/ProductList.htm

http://www.troisj.com/

http://www.winsite.com/bin/Info?1000000034270

http://www.cleandatasystems.com/

http://www.kliksoft.com/

http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm

http://www.accessui.com/

http://www.aislebyaisle.com/access/tools.htm

http://www.mindwarp-consultancy-software.com/mdbsecure-free-trial-download.html

http://www.dqwest.com/mdbartisan.htm

Office Automation - Smart Indenter
http://www.oaltd.co.uk/Indenter/Default.htm 

BMS Smart Indenter:
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=424894&Main=424894

http://www.zexersoft.com/products.html

http://www.vbaccelerator.com/home/Resources/Graphics_Library/Icons/Toolbar/Office/Access/article.asp

http://www.oscorp.com/downloads.asp

http://www.microtools.us/_product.aspx

http://www.users.cloud9.net/~dfurman/code.htm

http://www.devexpress.com/Downloads/ActiveX/XFreeLib/

Gnatt Chart Builder System:
http://www.bandwood.com/gbs.htm

Compare'EM Utility:
http://home.gci.net/~mike-noel/CompareEM

Access Auto Pilot:
http://www.access-autopilot.com/

http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm

http://www.vbaexpress.com/cooltools.php

Caller ID Software, Ms Access:
http://www.yes-tele.com/access.html 

http://www.acc-technology.com/

http://www.kellermansoftware.com/ 

MDE Source Code Protector v1.02 for Microsoft® Access:
http://www.everythingaccess.com/mdeprotector.htm

SQL Formatter:
http://www.sqlinform.com/

UI Builder for Microsoft Access
http://opengatesw.com/uidownloads.aspx

Headway Shortcut Builder
http://www.headwaysystems.com:80/ShortcutBuilder.htm

 


Top Top

 

Access Chats:

Live Access chats every Tuesday and Thursday:
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps


Top Top

 

Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Security FAQ On-line edition:
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

Lynn Trapp's Ten Security Steps:
  http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
  http://www.jmwild.com/security02.htm

The Microsoft Access Security Apparatus:
   http://www.grahamwideman.com/gw/tech/access/accesssec/index.htm 

  Real World Microsoft Access Protection And Security:
http://www.vb123.com/toolshed/00_accvb/accesssecurity.htm

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

The Security Whitepaper is also worth reading:
http://support.microsoft.com/?id=148555

Keith Wilby's Instructions (See step-by-step link)
http://www.keithwilby.co.uk/

Other Good Information:
http://www.access-experts.com/default.aspx?selection=
TutorialSecurity&sm=18

Steps to Securing an Access Database by Using User-level Security:
http://www.databasedev.co.uk/access_security.htm

Other Microsoft KB articles of interest:

Description of how to help protect a Access 2000 database:
http://support.microsoft.com/?id=254372

Description of the role of workgroup information files in Access security:
ACC97: http://support.microsoft.com/?id=303941
ACC2000: http://support.microsoft.com/?id=305541
ACC2002/2003: http://support.microsoft.com/?id=305542

Exploring Microsoft Access Security:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
dnacc2k2/html/odc_AcSecurity.asp?frame=true

http://geocities.com/jholimpo/
(Click on PDFs on the left side and select “Access Security”)

http://abcdataworks.com/security.htm

http://www.moretools.com:80/lessons/access_security.htm

 



Top Top


Creating menu bars and tool bars:

http://msdn.microsoft.com/library/default.asp?url=/archive/
en-us/dnaro97ta/html/ofcmdbar.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us
/dno2k3ta/html/odc_ofcmdbarbest.asp

http://www.access.qbuilt.com/html/forms.html#CustomCmdBar

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/achowCreateCustomMenuBarForCurrentDatabase.asp 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/ofdccCreateCustomMenu.asp 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/ofdccAddOrDeleteMenu.asp 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/ofhowAddCommandToMenu.asp

Programming Microsoft Office Command Bars:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
dnofftalk/html/office04042002.asp
 

http://www.jamiessoftware.tk/articles/menubars.html

 


Top Top

 

Access Replication:

  http://www.trigeminal.com/resources.asp?1033

  http://www.trigeminal.com/replication/splitrep.asp?1033

  How to un-replicate a database:
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm

Replication FAQ:
http://support.microsoft.com/?id=282977

Replication White Paper:
http://support.microsoft.com/?id=190766

http://www.access-experts.com/default.aspx?selection=
TutorialReplication&sm=18

Jet 4.0 Replication:
http://www.mvps.org/access/general/gen0033.htm

TSI Synchronizer:
http://www.mvps.org/access/modules/mdl0033.htm

Synchronization without Replication:
http://www.mvps.org/access/tables/tbl0015.htm

Database Replication in Microsoft JET 4.0:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/dbrepjet.asp

http://geocities.com/jholimpo/
(Click on PDFs on the left side and select “Replication FAQ” and “Replication”)

Sample files available here for study:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=
723926&page=9&view=collapsed&sb=5&o=&fpart=1

David Fenton's Jet Replication Wiki:
http://dfenton.com/DFA/Replication

 


Top Top

 

Additional Access Forums:

http://www.mdbmakers.com/forums/

http://www.utteraccess.com

http://www.access-programmers.co.uk/forums/

http://www.accessmonster.com/Uwe/ForumList.aspx

http://groups.yahoo.com/group/MS_Access_Professionals/

http://www.tek-tips.com/threadminder.cfm?pid=702

http://www.everythingaccess.com/forums/

http://www.accessgroup.it/
(In Italian)

http://www.officehelp.in/index/index.php/

http://groups.google.com/group/pl.comp.bazy-danych.msaccess?hl=en
(In Polish)

http://forums.devarticles.com/microsoft-access-development-49/

http://forums.microsoft.com/Technet/default.aspx?ForumGroupID=155&SiteID=17

 

 


Top Top

 

Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

  http://www.viescas.com/Info/books.htm
(Anything written by MVP John Viescas is a keeper)

  http://www.fmsinc.com/toplevel/books.htm

  http://www.mvps.org/access/resources/books.htm

  Real World Microsoft Access Database Protection and Security
by MVP Garry Robinson:
http://www.vb123.com/map/

http://tinyurl.com/eyvr8

  MVP Roger Carlson's list of recommended reading:
http://www.rogersaccesslibrary.com/linksRecommededreading.html

http://www.ForMereMortals.com

http://www.wrox.com/WileyCDA/Section/id-105060.html

http://www.bookpool.com/.x/RRRRRR/sm/1558609202

http://tinyurl.com/6j7xl

http://www.oreilly.com/catalog/accessannoy/index.html

http://www.awprofessional.com/title/0321245458

http://www.datapigtechnologies.com/AccessBook.htm

http://safari.oreilly.com/?XmlId=1-56592-358-8&g=paidora05

http://www.mcwtech.com/Books.aspx

http://www.databasedev.co.uk/reading.html

Grover Park George on Access: Access 2000, Access 2002, Access 2003:
http://www.amazon.com/gp/offer-listing/0972425896/ref=dp_olp_
1/104-4187736-4625504?%5Fencoding=UTF8&condition=all

http://www.programmingmsaccess.com/

Microsoft Access 2003 Forms, Reports, and Queries:
http://tinyurl.com/qtur2

Automating Microsoft Access with VBA:
http://www.amazon.com/gp/product/0789732440/ref=pd_rhf_f_2/104-4187736-4625504?%5Fencoding=UTF8

Programming Microsoft Office Access 2003:
http://www.amazon.com/gp/product/0735619425/ref=pd_sim_b_5/104-4187736-4625504?%5Fencoding=UTF8&v=glance&n=283155

Access 2003 Programming by Example with VBA, XML, and ASP:
http://www.amazon.com/gp/product/1556222238/ref=pd_sim_b_3/104-4187736-4625504?%5Fencoding=UTF8&v=glance&n=283155

Microsoft Access 2000/Visual Basic for Applications Fundamentals (Paperback):
http://www.amazon.com/gp/product/0735605920/sr=8-1/qid=1151364032/
ref=pd_bbs_1/002-6087452-1377636?redirect=true&ie=UTF8 

Access 2002 VBA Handbook (Paperback):
http://www.amazon.com/gp/product/0782140130/ref=pd_bxgy_img_b/
002-6087452-1377636?redirect=true&ie=UTF8 

Sams Teach Yourself Microsoft Access 2002 Programming in 24 Hours (Paperback):
http://www.amazon.com/gp/product/0672320983/sr=8-1/qid=1151363892/
ref=sr_1_1/002-6087452-1377636?redirect=true&ie=UTF8

 

 


Top Top

 

Access Publications:

http://www.smartaccessnewsletter.com/ME2/Audiences/default.asp

http://accessvbsqladvisor.com/

http://www.intelligententerprise.com/info_centers/database/

http://www.dbmsmag.com/artindx.shtml


Top Top



Access BLOGS:

  http://alexdyb.blogspot.com/

  http://vb123.blogspot.com/

  http://msmvps.com/blogs/access/

  http://blog.datamanagementsolutions.biz/dms.html

  http://pschmid.net/blog/index.php 

http://accessextra.blogspot.com/index.html

http://blogs.msdn.com/access/

http://oakleafblog.blogspot.com/ 

http://blogs.msdn.com/thirdoffive/default.aspx 

http://blogs.msdn.com/clintcovington/ 

http://blogs.msdn.com/jensenh/default.aspx

http://blogs.msdn.com/frice/

http://accesspro.blogspot.com/

 

 


Top Top

 

Access User Groups/Special Interest Groups:

http://www.paug.com

http://www.pnwadg.org/

http://www.datadynamicsnw.com/accesssig/

http://www.DAAUG.org

http://68.149.211.56:29994/

http://www.ravey.net/aug/

http://cpcug.org/user/access/

http://www.ukaug.co.uk/

http://members.tripod.com/ntaccess/

http://www.hal-pc.org/~SIG/

http://www.ssw.com.au/ssw/

http://www.arimsoft.ru/msaccess/

http://www.bostonaccessday.com/

  Wellington Office User Group:
http://www.woug.info/

 


Top Top

 

Some of the MVP web sites:

  http://www.mvps.org/links.html


Top Top

 

Database Recovery:

  Fix Your Corrupt Access Database In 30 Minutes:
http://www.vb123.com/fixaccess/

http://www.pksolutions.com/

http://www.atroplan.com/

AccessFix Software
http://www.cimaware.com/accessfix.html

http://www.accessdatabaserecovery.com/

http://www.msaccessrepair.com/

 

 

Top Top

© Copyright 2005-2010 Conrad Systems Development - All Rights Reserved

This page was last updated on Tuesday, March 05, 2013.

Site created with FrontPage