Form Corrupts a Query

[Guest]

I have Access 2000 (9.06926 sp-3).

I have created a table and a simple query that sorts on 1 field a select on
2 fields (one alpha, one numeric). There are 7 fields in the query.

I save the query and it works as intended.

Then I create a form and select the fields I want to see

I save the form with Form as the default view.

Then I change the form to have Datasheet as the default and only allowed view.

I save the form.

I try to run the form

It open it, and I get a Type Mismatch Error.

When I look at the query again, all 7 fields are the same field (???) and
the selection criteria have been now clumped together under the 1st field
(remeinder, all of which are the same now). This field is numeric and since
one of the selection criteria had been alpha - this is in error - hence the
Type Mismatch Error.

It appears that the only time this gets corrupted is if I make any change at
all in the design mode or live mode to the form.

If create the form initially and set the default and allowed views to
Datasheet and run the form, it works.

But if I change the column width or row height and exit - the query gets
corrupted as described above.

I have talked to a developer in the UK and says this problem does not happen
in Office 2003 with SP-1.

Is this an Office 2000 bug - and is there a patch?

 

[Allen Browne]

Name AutoCorrect would the first suspect for the problem you describe.

Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

Then compact the database:
Tools | Database Utilities | Compact

That will probably be enough to solve the problem, but you could also
decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact again.

You have the right SP for Office 2000. You should also check that you have
SP8 for JET 4. If not, it's available from:
http://support.microsoft.com/kb/239114