Browse by Tags

All Tags » Access » Jet (RSS)
Monday, December 10, 2007 11:42 PM

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: , ,
Friday, November 30, 2007 4:56 PM

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: ,
Thursday, September 27, 2007 7:16 PM

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: ,
Wednesday, September 05, 2007 6:39 PM

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: ,
Thursday, August 30, 2007 7:00 PM

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: , ,
Tuesday, July 17, 2007 2:56 PM

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: ,
Monday, July 16, 2007 6:59 PM

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: ,
Saturday, July 14, 2007 5:25 PM

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