ACCESS 2003 - HOT FIX ???

[pauld]

Ever since installing Hot Fix #1 for Access 2003 w/SP3, I am experiencing
random "blank" fields when I export a Query to Excel. It's usually the same
1-2 fields out of 6 that are part of the query.

The data in the Table is definitely there...and the Query is a straight
forward Select query with no Criteria in any column. Just selecting 6 of the
fields from the table.

Might there be a Hot Fix #2 ?

Any other ideas on why this might be happening.

 

[Paul Shapiro]

I don't know hotfix numbers, but here's a reference to an A2003 post-SP3
hotfix from September 2008:
http://support.microsoft.com/kb/956722
Check the MS office website to see what else you can find.

 

[aaron.kempf]

sounds to me like Jet isn't reliable enough for you.

I'd move to SQL Server, personally

-Aaron

 

[Tony Toews [MVP]]

Ever since installing Hot Fix #1 for Access 2003 w/SP3, I am experiencing
random "blank" fields when I export a Query to Excel. It's usually the same
1-2 fields out of 6 that are part of the query.

Please ignore Aaron's posting as Aaron's answer to just about every question is SQL
Server and ADPs. No matter how appropriate his answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/