Browse by Tags

All Tags » Access » Hard core (RSS)

The awesome, and free, MZTools utility

Every time I do any work in VBA I’m very grateful for the, free for us, MZTools utility.  Among the many features the ones I really like are: The find screen as it displays a list of all the lines of code containing your search string.  You...

Sigh

If there’s one thing I hate it’s looking at my excellent code written a year or two ago and thinking “Why on earth did I do something so stupid?”

Queries On Steroids ... Part IV

I was reminded of this article in a discussion in a newsgroup/forum.   As I’m always interested in the hard core details of anything computer related but especially anything to do with Access or Jet I thought I’d share this with you. Queries...
Posted by Tony | with no comments
Filed under: , ,

I've never quite trusted ADO because …

I've never quite trusted ADO because I've never understood how their versioning system works. I just couldn’t see the various versions DLLs on my system and yet the Access references window showed five or six different versions..   Jet...
Posted by Tony | 7 comment(s)
Filed under: , , ,

How do you create a mdb database file in Python?

An interesting question was asked on StackOverlow. The answer was surprisingly easy (assuming the answer was accurate of course. <smile>)  See How do you create a mdb database file in Python? I should add that I have no idea what Python is...
Posted by Tony | 1 comment(s)
Filed under: , ,

Puzzling problem with Access’s built in Shell function

I was testing some code, which will be available in a few days as part of a new release of the Auto FE Updater, which uses the Access shell function to start the Auto FE Updater. I could hear the beep sound but I couldn’t see the customized form to display...
Posted by Tony | 8 comment(s)

Multi select files in the standard Windows File Open/Save dialog box

I hadn’t realized that this API code had been enhanced to support selecting multiple files until Tom Wickerath mentioned that he and Arvin Meyer had worked with Ken Getz to get this working. API: Call the standard Windows File Open/Save dialog box
Posted by Tony | with no comments
Filed under: , , ,

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: , ,

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: , ,

Access / DotNet hybrid: yes it's possible

Tom van Stiphout starting a very interesting posting on Access and .Net interoperability. Access / DotNet hybrid: yes it's possible Options I mention this more as an intellectual curiosity as I think Access does a fine job. And can easily work at...
Posted by Tony | with no comments
Filed under: ,

So what are the undocumented SysCmd items?

In my previous posting I linked to Undocumented SysCmd Functions . So I was curious and created my own code to go through the various SysCmds. I came up with the following code. Sub FindSysCmds() Dim ReturnCode As Variant, i As Long On Error GoTo tagError...
Posted by Tony | with no comments
Filed under: ,