DeskLot Support

Support Article 36

Problem

DeskLot Error at Location 9501. Error Code -2147217887 - Cannot include Memo, OLE, or Hyperlink objects when you select unique values

Solution

This problem has only occurred in our tests on virgin Windows installations and Windows installations that are NOT running up-to-date service packs (such as Windows XP Service Pack 2). This problem is a result of a known bug in the Microsoft Jet 4.0 database engine.

See: http://support.microsoft.com/kb/304431

In our tests (on a Windows XP machine), this issue was resolved by visiting http://windowsupdate.microsoft.com/ and installing all Microsoft Updates and MOST importantly, updating the Windows XP installation to Service Pack 2.

NOTE: When visiting windowsupdate.microsoft.com, after it asks you to reboot your computer, KEEP GOING BACK to the site and checking for updates again until it tells you there are no updates at all. For virgin Windows installations, it can take numerous trips and reboots to get your computer fully up to date.

If you want to skip updating your Windows installation to the latest service pack, you may download the latest Microsoft Jet 4.0 Service Pack at http://support.microsoft.com/kb/239114/. This also solved the problem in our tests. HOWEVER, you really should get all of the way up-to-date with Microsoft updates via windowsupdate.microsoft.com!

Keywords

Location 9501,9501, -2147217887, 2147217887,Cannot include Memo, OLE, or Hyperlink objects when you select unique values