vb123.com

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

 

Home  Contact Us
Order our Software


 Smart Access  
The Magazine that Access Developers loved to read and write for is back
Article Index Here or Read More

See 2010 Specials

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

  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

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

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

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

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


Datamining/Graphs

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

DryToast 
Backup and query your BaseCamp
® projects
Read More

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

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox  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
 

 

Next Tip    Links for ADO/Access Security and Related Issues

Find out about ADO and DAO and lots of the material discussed in this article
http://msdn.microsoft.com/library/en-us/dndao/html/daotoadoupdate.asp

Database provider constants for provider Microsoft.Jet.OLEDB.4.0
http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefjetprovspec.asp

Probably the best page on this topic
http://msdn.microsoft.com/library/en-us/dndao/html/daotoadoupdate_topic4.asp

Access Provider default values for ADO
http://msdn.microsoft.com/library/en-us/ado270/htm/mdproproviderx.asp

Discussions on the MSDASQL provider (ODBC) with ADO.
http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefodbcprovspec.asp

HOWTO: Automate a Secured Access Database Using Visual Basic
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q192919&FR=0

This page shows you how to shell out Access to use a path
http://www.mvps.org/access/modules/mdl0036.htm

If you are going to use DSN files,  a good place to start would be
http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefodbcprovspec.asp

Other Pages

Microsoft Access Security And Passwords

Backing Up Your Access Data With XML

A Wizard To Turn SubDataSheets Into Shaped ADO Recordsets

Persistent Caching >>>Take a Load Off Your Server with Access 97/2000

Click on the Next Tip button for the next links page.


 

 

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