I'm using a database written in Access 2002-2003 format. All recent updates/patches have been applied including latest Microsoft Jet Service Packs and SP2. The problem began after I Compacted/Repaired the database. Here's the behavior:
(1) A table that has an autonumber field as a primary key, generates a number that is NOT unique (already exists in the table) even though it specifies 'No Duplicates'.
(2) A Combo box that uses a query of country names, stopped suggesting a country when you start typing in it. For example, if you type S, it suggests Sweden and if you follow with a Y, it shows Syria. That behavior is no longer there. The odd thing is that none of the combo boxes now show any inclination of showing a suggested item from the list based on what one types.
Here's what I've done so far:
(a) Repaired and compacted the database: No change in above behavior
(b) Recreated the entire database by transferring tables, queries, forms, etc, to a new empty database: Behavior for article 1 is fixed but no change in behavior of article 2
(c) Deleted one of the combo boxes and recreated it. All combo boxes started working well...that is until I exited the database and got back into it then the combo boxes stopped working as outlined in article #2.
(d) Removed Office 2003 and reinstalled: No change in combo boxes odd behavior
(e) Tried the database on a different system with the same configurations as mine. Same issue with the combo boxes.
(f) Created a totally different database with combo boxes. These combo boxes do work as expected all the time.
My boss thinks it's a code within the database that is triggering this behavior. But there isn't any really. None of the combo boxes I looked at had any event code attached to them. Most were created with the Access combo-box wizard. Any ideas what else to try?