There are two basic approaches to increasing the probability of a fully successful upsizing operation:
If your Jet application is relatively simple or in the early development stage and doesn't include VBA code that has reference to any version of DAO, the trial-and-error method might be your best choice. The most efficient upsizing method usually is a combination the two approaches. Tip Replace all instances of Like expressions for date constraints in Jet query WHERE clauses with Between...And expressions. For example, change Like "*/*/1997" to Between #1/1/1997# And #12/31/1997#. The Wizard upsizes Like "*/*/1997" to LIKE '%/%/1997", but the upsized query returns no rows in the project designer. |