Browse by Tags

All Tags » Jet » Access (RSS)
Wed, Aug 17 2011 19:14

Access 2010 Compact & Repair breaks autonumber seed if index is descending

While this is very unusual having more than 1000 records in an Access 2010 MDB with the autonumber index in descending sequence a compact and repair loses the seed and the next record inserted fails. Note this is the Microsoft partner forums so if you...
Posted by Tony | 4 comment(s)
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: , ,
Tue, Dec 23 2008 15:36

The case of the form which took 30 seconds to open

The client had two transaction file forms which took 30 seconds to open while a similar form took 3 or 4 seconds to open. I went through many of the items on my Microsoft Access Performance FAQ page and none made a significant difference. The list of...
Posted by Tony | 2 comment(s)
Filed under: , , ,
Mon, Dec 10 2007 23:42

Resetting autonumber seed to the highest used value

Executing an append query which has a value in the autonumber field can set the autonumber seed to a unwanted high value. Or maybe you had some code running amok, or amuck if you prefer that spelling, which accidentally inserted a lot of records. In Access...
Posted by Tony | with no comments
Filed under: , ,
Fri, Nov 30 2007 16:56

Interesting KB article on DAO and Jet DLLs

There's been an interesting discussion on Jet and DAO dlls in the newsgroups. James A. Fortune, long time newsgroup resident, located some interesting KB articles in the thread titled Jet Database Engine Questions He did located other articles but...
Posted by Tony | with no comments
Filed under: ,
Thu, Sep 27 2007 19:16

How to get at Jet warnings that are not errors

How to get at Jet warnings that are not errors by Michael Kaplan. Note the discussion about "There is the Jet 4.0 feature of record level locking that people love ...".
Posted by Tony | with no comments
Filed under: ,
Wed, Sep 5 2007 18:39

Interested in the bowels of the MDB file layout?

MDB Tools is a set of open source libraries and utilities to facilitate exporting data from MS Access databases (mdb files) without using the Microsoft DLLs. Thus non Windows OSs can read the data. Or, to put it another way, they are reverse engineering...
Posted by Tony | with no comments
Filed under: ,
Thu, Aug 30 2007 19:00

If an index is a duplicate of another index then ...

Visit If an index is a duplicate of another index then Access/Jet does not take any extra space to read the article and download a zip file containing the sample MDB to see for yourself. I do have a tool available to find duplicate indexes but it needs...
Posted by Tony | with no comments
Filed under: , ,
Tue, Jul 17 2007 14:56

One feature that DAO is missing - resetting autonumber seed

Using queries you can insert and delete a dummy record thus resetting the autonumber seed higher. I don't know why you'd want to do this of course as the user should never see an autonumber value. In ADOX you can reset the autonumber seed value...
Posted by Tony | with no comments
Filed under: ,
Mon, Jul 16 2007 18:59

When is an autonumber value allocated?

An autonumber value is allocated as soon as a user hits one character or digit in any field in a new record. If, a millisecond, later another user or program creates another record, even if no data has yet been saved by the first user or program, the...
Posted by Tony | with no comments
Filed under: ,
Sat, Jul 14 2007 17:25

What does DAO have that ADO/ADOx/JRO do not?

An interesting and still very relevant seven year old article by Michael Kaplan aka michka. What does DAO have that ADO/ADOx/JRO do not?
Posted by Tony | with no comments
Filed under: ,