vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

   Microsoft Access Protection - Book Links

Surveillance Of Users And Objects 

Is Your Database Secure ? Need to know more about how to protect your database investment. Confused about Access security. Then have a look at the book that Garry is writing for Apress.
Click here for book link

Download Jetutils.exe and related files from http://support.microsoft.com/default.aspx?scid=kb;en-us;176670

Use ADO to Return a List of Users Connected to a Database (JetUserRoster)
http://msdn.microsoft.com/library/en-us/dnimo01/html/o2k0135.asp

More on the Jet Roster and a technique to Identify Users
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovridentifyingusers.asp

Download the latest version of ADO from Microsoft
http://www.microsoft.com/data/

More information on GUID's
Click Here

Use Connection Control to Prevent User Log On at Run Time in Access 2000 (Microsoft Knowledge Base Article – 198756)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q198756

The White Paper On Understanding Microsoft Jet Locking (LDB Files) by Kevin Collins
http://www.microsoft.com/ACCESSDEV/Articles/jetlund.htm

Papers discussing the LDB file and how it works (2002/97)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;208778
http://support.microsoft.com/default.aspx?scid=KB;EN-US;136128

Troubleshoot corruption issues to reduce suspect state and connection problems
http://support.microsoft.com/default.aspx?scid=KB;en-us;109953&

How to detect idle time or inactivity
http://support.microsoft.com/default.aspx?scid=KB;en-us;128814

Microsoft Access Passwords, Workgroups, ADO and customized Connection strings.
http://www.vb123.com/toolshed/02_docs/accessadosecure.htm

How To Shut Down A Database Remotely (Microsoft Knowledge Base Article – 304408)
http://support.microsoft.com/default.aspx?scid=kb;en-us;304408

Handling record locking conflicts in Access
http://www.developer.com/tech/print.php/10923_721911_2

Record locking in Access
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconAvoidingDataLockingConflictsS.asp?frame=true

Page level verses record level locking
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrpagelevellockingvsrecordlevellocking.asp

New Features in ADO, ADOX and JRO including Jet User Roster
http://msdn.microsoft.com/library/en-us/dndao/html/daotoadoupdate_topic10.asp

API to retrieving the Windows User ID (Microsoft Knowledge Base Article – 152970)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q152970

API to retrieving the Computer Name (Microsoft Knowledge Base Article – 148835)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q148835

Learn about ADO and find the latest downloads
http://www.microsoft.com/data/ado/prodinfo/progmod.htm

Find out about and download the latest version of The Access Workbench
http://www.vb123.com/workbench/

The Total Access Admin product from FMS provides you with user logging software
http://www.fmsinc.com/products/Admin/index.asp

Get the Novell User Name
http://www.experts-exchange.com/Databases/MS_Access/Q_20171232.html

Download the free version of The Access Workbench. Find your registration number in the book appendices.
http://www.vb123.com/get/workbench_map_free.zip


 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals