Tech Talk
Here is a collection of tips and solutions (some of our own, some from other sources) that we'd like to share with other hard working software developers and careful computer trouble-shooters.
The following information is provided as a gesture of goodwill and cannot be guaranteed to work since every system is unique. Please understand that if you decide to use them that you do so entirely at your own risk. As always, it is vital that you make adequate backups.
Microsoft Access 2007
1.Exporting Access Tables to SQL Server Issues
When attempting to export a Microsoft Access table to SQL Server
using the "Export to ODBC Database" functionality, the export can fail
with the rather confusing message:
"The expression is typed incorrectly, or it is too complex to
be evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning parts
of the expression to variables"
This happened to us and on investigation we found that it was caused by invalid dates in one or more of the tables Date/Time type fields. A quick way of finding them is to open the table and Sort A to Z each date column in turn. The "bad" dates usually appear at the top of the sorted dates (sometimes shown as a time). Correct or remove these dates and try again. It worked for us!
2. Access Datasheet Interactive Filtering Fails
When
clicking on a column header "down arrowhead" interactively to use the
built-in filtering feature of an Access 2007 datasheet (see opposite)
you may get an error instead of the list of items on which to filter.
We found that this went away after applying Access 2007 SP2.
Microsoft Word
General links to solve problems I've encountered with customer's computers.