Browse by Tags

All Tags » Access (RSS)
Sat, Oct 24 2009 15:51

Jackcess is a pure Java library for reading from and writing to MS Access databases.

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.
Posted by Tony | 2 comment(s)
Filed under: , ,
Sat, Oct 24 2009 15:01

Jet Engine History

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...
Posted by Tony | 1 comment(s)
Filed under: , ,
Wed, Sep 23 2009 15:32

InStrRev

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...
Posted by Tony | 1 comment(s)
Filed under: , ,
Tue, Sep 22 2009 22:32

Queries and the 3061 "Too few parameters. Expected 1." message

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...
Posted by Tony | 2 comment(s)
Filed under: , ,
Tue, Sep 8 2009 16:53

A new version of the Auto FE Updater is available

A new version of the Auto FE Updater is available at my new, somewhat reorganized website http://www.autofeupdater.com/ Added FileExtension and FileExtensionSimple to the StartMethod.   This now means the utility can be used for ADP/ADEs or...
Posted by Tony | 1 comment(s)
Filed under: ,
Thu, Aug 6 2009 14:55

An approach to sending text messages from within an Access application

Steve Schapel, fellow Access MVP, answered a question about sending SMSs with a page on his website.  An approach to sending text messages from within an Access application    I can see this capability being quite useful in some consumer...
Posted by Tony | with no comments
Filed under: ,
Thu, Jun 25 2009 16:48

Misleading error message - "Microsoft Access Was Unable to Create an MDE Database"

Someone got this message using Access 2003 but this could also apply to other versions of access. Clicking help on the error message then displays "This error is usually associated with compiling a large database into an MDE file. Due to the method...
Posted by Tony | 1 comment(s)
Filed under:
Thu, Jun 18 2009 16:16

Steps to think about when doing a data MDB back up, compact or zip.

I have a button on my Granite Fleet Manager app which allows the user to do a backup of the backend data MDB. I also have two other buttons which zip and email the backend data MDB to either themselves for backup purposes or to me for support purposes...
Posted by Tony | with no comments
Filed under: , ,
Sun, Jun 14 2009 18:28

An older version of MSCOMM32.OCX has had the "kill bit" flag set.

The latest Windows Update has set the kill bit flag for an out of date but commonly used version of mscom32.ocx. Microsoft Security Advisory (969898) Options - roll back the update. Not recommended however instructions are in the above web page. - locate...
Posted by Tony | 10 comment(s)
Filed under: , , ,
Mon, Jun 1 2009 20:23

Smart Access Magazine

Garry Robinson, fellow Access MVP, has purchased the Smart Access Magazine . there was 300 articles/2000 pages written by over 100 of best Access professionals in the world under the guidance of editor Peter Vogel. (Although I do recall emailing a few...
Posted by Tony | 1 comment(s)
Filed under:
Sat, May 23 2009 17:57

DbUtilities - Transfer object permissions from a secured database to a new database container

The first item "is a fantastic re-write of DbUtilities which, as an Add-in, makes it easier to transfer the object permissions from a secured database to a new database container. " Author: Jeff Conrad (aka "Access Junkie"), former...
Posted by Tony | with no comments
Filed under: ,
Thu, May 21 2009 20:31

Redimming an array 1,000,000 times takes 4.63 seconds

The following question was asked at StackedOverflow. How do you redimension an array in VBA? . One response was some detailed code showing how to redim an array efficiently by doubling the number of elements. This took 0.41 seconds for a million records...
Posted by Tony | with no comments
Filed under: , ,
Thu, May 21 2009 18:58

Latest Access 2003 hotfix - 970623

"When you try to import all objects from an Access 2003 database into a new one, you receive the following error message: There isn't enough free memory to update the display. Close unneeded programs and try again." Access 2003 hotfix package...
Posted by Tony | with no comments
Filed under: ,
Tue, May 12 2009 20:57

Office 2010 The Movie

Office 2010 The Movie Interesting video that. But notice the link to the Office 2010 blog .
Posted by Tony | with no comments
Filed under: ,
Tue, May 12 2009 20:25

Microsoft Office 2010 Technical Preview

The Microsoft Office 2010 Technical Preview is a limited, invitation only program which will provide you with the opportunity to experience early, pre-release versions of Office 2010 which will include the following applications: Word 2010, Excel 2010...
Posted by Tony | with no comments
Filed under: ,
Fri, May 8 2009 17:14

Exceeding 2 Gb MDB file size (and a bit of TGIF humour)

Exceeding the 2 Gb MDB file size gives you an exceedingly misleading error message: In Jet 4.0 one message that is received when the 2 Gb file size is exceeded is invalid argument. This is, of course, utterly confusing and can mean other things such as...
Posted by Tony | 2 comment(s)
Filed under: ,
Mon, May 4 2009 23:31

Dreaming of Rails as the Next Microsoft Access

An interesting blog posting titled Dreaming of Rails as the Next Microsoft Access (Rails meaning Ruby on Rails of which I know nothing other than having seen the occasional reference it.) Now I disagree with the authors characterization of us as "Office...
Posted by Tony | with no comments
Filed under: ,
Mon, Apr 27 2009 19:48

The problems with currency fields

The Access help on currency fields states: Use a Currency field to prevent rounding off during calculations. A Currency field is accurate to 15 digits to the left of the decimal point and 4 digits to the right. A Currency field occupies 8 bytes of disk...
Posted by Tony | with no comments
Filed under:
Mon, Apr 27 2009 16:02

I sure hope there is a final exam on this course

Project title: Need 15 Queries in Access "I need someone who can make 15 queries in Access 2007 and have to be done in sql view (this is a must). I want this for school home work and need them fast, as soon as possible. I will provide you with the...
Posted by Tony | with no comments
Filed under: , ,
Sun, Apr 26 2009 15:35

Access Demos, tutorials and basics

Thanks to a posting by Bill Mosca Access (2007) Demo Videos can be found at Access Demos Also see Access Basics by Crystal fellow Access MVP. She also has some Video Tutorials
Posted by Tony | with no comments
Filed under: , ,
More Posts Next page »