Browse by Tags

All Tags » Jet » Tips (RSS)
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: , ,
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: , ,