Browse by Tags

All Tags » Hard core (RSS)
Mon, Nov 29 2010 18:14

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...
Posted by Tony | 5 comment(s)
Filed under: , , , ,
Wed, Nov 24 2010 23:49

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?”
Posted by Tony | 4 comment(s)
Filed under: , , , ,
Fri, Oct 15 2010 17:07

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: , ,
Thu, Jul 1 2010 18:56

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: , , ,
Wed, Jun 23 2010 21:31

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: , ,
Tue, Jun 22 2010 23:53

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)
Filed under: , , ,
Fri, Feb 5 2010 12:46

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: , , ,
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: , ,
Thu, Jan 1 2009 19:32

Internals viewer for SQL Server

Internals viewer for SQL Server I always enjoy peeking under the covers. Hey, computer software covers. Get your mind out of the gutter. This blog posting mentions how to poke about under the covers of SQL Server. Similar to MDB Tools - A set of libraries...
Posted by Tony | with no comments
Filed under: , ,
Sun, Aug 24 2008 17:49

Back to the basics - don't forget to run a memory diagnostic program

A friend was having very weird problems with his PC. Virus scans would halt on random files. The system would slow down or stop at random intervals. It would occasionally reboot with bizarre BSOD's (Blue Screens of Death.) I had no idea what the problem...
Posted by Tony | 2 comment(s)
Filed under: ,
Thu, Aug 14 2008 22:46

MS08-041 : The Microsoft Access Snapshot Viewer ActiveX control

MS08-041 fixes a vulnerability in the Microsoft Access Snapshot Viewer ActiveX control. It’s an interesting vulnerability so we wanted to go into more detail about platforms at reduced risk and also more about the servicing strategy for this vulnerability...
Posted by Tony | with no comments
Filed under: ,
Tue, Jun 24 2008 21:04

Add two items to your computer tool kit

Add two items to your computer tool kit Indeed there are some low priority files I want to get off my old laptop hard drive. It's been sitting in the freezer for a few months now so it should be cold soaked. <smile> Good idea about the blue...
Posted by Tony | with no comments
Filed under:
Thu, Oct 18 2007 17:40

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: ,
Sun, Aug 19 2007 16:39

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