I just came across this interesting Open Source project - Jackcess is a pure Java library for reading from and writing to MS Access databases.   Also read the FAQ.  Also note the link to MDB Tools which hasn’t been updated since 2004.

A question started a bit of digging and poking about.   I’ve always been interested in the history of Access and Jet and the code names used way back when such as Cirrus.  The Wiki Microsoft Jet Database Engine article had a footnote referencing a page titled Jet Engine: History Regretfully all the links mentioned on that page no longer work.  Although some of the MS white papers mentioned might still be available by digging. Which reminds me. There are two versions of the Microsoft

For those of you who don't know, Office DevCon ( http://www.officedevcon.com.au) is the largest and most popular annual community-driven conference in the southern hemisphere. It allows Microsoft Office developers and power users to come together in one location to hear expert speakers from around the world present on a wide range of Microsoft Office-related topics. Over 2 days, you will hear in-depth presentations on advanced Office System technologies for Office 2003 and 2007, and 2010 (the

“What's far less well known is that Adobe Flash software also features cookies that can be used in much the same way as HTTP cookies. Flash cookies can be used for storing the volume level of a Flash video but the technology can also be used as "secondary, redundant unique identifiers that enable advertisers to circumvent user preferences and self-help", the academics warn. A significant percentage of websites including federal government sites use this Flash-based technology to track

I’m working on some largish updates to the Auto FE Updater and I wanted to ensure that the new routine which logs errors would properly handle the situation if there were errors in the error logging routine.  A great deal of searching a dimly remembered discussion brought me to fellow Access MVP Dirk GoldGar’s posting on this topic.  How to know when a Connection or Recordset is open in Programming If Not rs Is Nothing Then     rs.Close: Set rs = Nothing End If If Not gblLogdb

Added ShortCutComment to INI file for the user to see when hovering over a shortcut. Fixed bug where if creating both a Program Files shortcut with a folder and a desktop shortcut the utility would attempt to add the shortcut to a folder to the desktop - Thanks to Noel Mann of New Zealand for the ShortCutComment suggestion and the above bug report Utility will now correct shortcut icon where the user has updated that field or the admin wants to change them. Fixed various minor bugs and created better

Added the following to the Microsoft Access Email FAQ - CDO aka CDONTS web page. Collaboration Data Objects, version 1.2.1 Beginning in Exchange Server 2007 and Outlook 2007, CDO 1.2.1 will no longer be provided as a part of the install of the product. As a result, there is functionality missing that many applications depend upon. CDO 1.2.1 is a package providing access to Outlook-compatible objects through a COM-based API. Microsoft Exchange Server MAPI Client and Collaboration Data Objects 1.2

I’ll be darned.  I had no idea InStrRev existed in VBA code.  It is new in Access 2000 so it’s been around for nine years.  I had to build this function myself in A2.0 or A97 to get the file name from a string which had the path and file.   The code needed to find the right most occurrence of “\” back slash.  I’ve been happily using my function ever since.   I actually learned something new about Access this year.  <smile>

Your query is working just fine referencing a form to select some records: but when you run it in code you get the dreaded 3061 "Too few parameters. Expected 1." message. One option is to evaluate the Forms![Form name]![Field Name] expression as per the following examples. The below example is an execute query. Set db = CurrentDb Set qdf = db.QueryDefs("LEMBatchesRpt Append to temp table") For i = 0 To qdf.Parameters.Count - 1     qdf.Parameters(i) = Eval(qdf.Parameters

Added ProgramsMenuFolder option to create a folder in your Start >> All Programs menu for such shortcuts. Added buttons to open the server folder or the Main App Folder in Windows Explorer.  If the user gets an error message they only see the button to open the Main App Folder. Fixed bug where StartMDB.exe was staying in memory introduced in version 1.77 Changed StartMethod=FileExtension to use a different API call as the API call I chose to use did not handle file extensions longer than